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
[Uploaded an Excel file]
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
[Uploaded an Excel file]
Excelchat Expert
21/08/2018 - 08:27
Please tell me what problem you are facing, would be happy to help you
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
[Uploaded an Excel file]
User
21/08/2018 - 08:57
downloading.
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
[Uploaded an Excel file]
Excelchat Expert
21/08/2018 - 09:00
[Uploaded an Excel file]
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
yes please
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.