**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.*