# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm not sure as to why my formula isn't working. I will send two files... Workbook 1.xlsx.xls Workbook 2.xlsm The problem is in Column H of Workbook 1.
Solved by E. H. in 42 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 21/08/2018 - 08:22
Hi, Welcome to Got It
Excelchat Expert 21/08/2018 - 08:23
How are you doing today?
User 21/08/2018 - 08:23
User 21/08/2018 - 08:23
Good
User 21/08/2018 - 08:23
yourself?
Excelchat Expert 21/08/2018 - 08:23
I'm doing good thank you
User 21/08/2018 - 08:26
Excelchat Expert 21/08/2018 - 08:27
User 21/08/2018 - 08:28
The formula is returning a #REF error.
Excelchat Expert 21/08/2018 - 08:29
Sure, I'm checking
Excelchat Expert 21/08/2018 - 08:33
Can you please help me to know, what you exactly want to see in the Workbook1 where the formula is returning #REF error
User 21/08/2018 - 08:37
I'm wanting the formula to search for sheet number (col A) and part number (col b) in workbook 2
User 21/08/2018 - 08:37
and then return the number from col I in workbook 2 to the
User 21/08/2018 - 08:38
cell
User 21/08/2018 - 08:38
column I being a price in the corresponding sheet number
User 21/08/2018 - 08:40
for example
Excelchat Expert 21/08/2018 - 08:40
Yes that would be great to see an example
Excelchat Expert 21/08/2018 - 08:40
As this is bit unclear to me
User 21/08/2018 - 08:43
please goto the LOOKUP TAB sheet on workbook 1.xls the formula will search in workbook 2 for 15382100...
Excelchat Expert 21/08/2018 - 08:44
Was it working before?
User 21/08/2018 - 08:46
yes.
User 21/08/2018 - 08:46
one of you kind GOT IT experts helped me to develop the formula
User 21/08/2018 - 08:46
and then the formula will look for B2 and from B2 it will pull the cost in colum I of that sheet back to the cell
User 21/08/2018 - 08:51
Hello?
Excelchat Expert 21/08/2018 - 08:51
Yep, I'm trying to solve your problem dear
User 21/08/2018 - 08:51
Sorry.
User 21/08/2018 - 08:51
i'll be patient.
User 21/08/2018 - 08:52
if youd like to scrap the formula and create one from scratch. i'd be ok with that
Excelchat Expert 21/08/2018 - 08:52
Sure
Excelchat Expert 21/08/2018 - 08:57
Please check, I've solved and it's working fine now
User 21/08/2018 - 08:57
User 21/08/2018 - 08:57
checking
Excelchat Expert 21/08/2018 - 08:58
Sure
Excelchat Expert 21/08/2018 - 08:58
Values do appeared
Excelchat Expert 21/08/2018 - 08:59
Excelchat Expert 21/08/2018 - 09:00
User 21/08/2018 - 09:02
That works. what did you change?
Excelchat Expert 21/08/2018 - 09:03
Well the convention was not proper, I changed to the correct one. Like the name given to Workbook in formula was not correct, hence changed and worked.
Excelchat Expert 21/08/2018 - 09:03
Hope this solves your problem :)
User 21/08/2018 - 09:03
It does. thanks!
Excelchat Expert 21/08/2018 - 09:03
Should we close the session as this solved your problem :)
User 21/08/2018 - 09:04
Excelchat Expert 21/08/2018 - 09:04
Can I have 5 start rating for this service after session? :)
User 21/08/2018 - 09:04
of course... you solved my issue
Excelchat Expert 21/08/2018 - 09:04
My pleasure to help, it was really nice meeting you
Excelchat Expert 21/08/2018 - 09:04
Have a good time, God bless you :)
User 21/08/2018 - 09:05
God bless you as well
Excelchat Expert 21/08/2018 - 09:05
Ending session and hope to see you again :)
User 21/08/2018 - 09:05
have a great day
Excelchat Expert 21/08/2018 - 09:05
:)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.