workbook lookup

M

Max_power

Hello,

I was wondering why certain lookups that I am performing won't function
properly. I have say workbook1 and I want to do a lookup in workbook2
but when I click on workbook2 the lookup won't work ie I get the
message "update values" for workbook.
It was working before but just doesn't work now, anyone have any
ideas?
So I have something like
=VLOOKUP(A2,'[WORKBOOK2.XLS]SHEET1'!B:B,1,FALSE)

Many thanks
 
D

Don Guillett

You don't need to open the other workbook.Try this
=VLOOKUP(C2,'C:\yourfolder\[yourfile.xls]yoursheet'!$A$7:$H$18,2)

best to use a range instead of the entire columns. shouldn't you be trying
to lookup something to the right of where you find your value. B2:c200, 2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Automatically closing slave workbook when main workbook is closed... 0
Stop Command Question 4
Copy worksheet to 2nd workbook but have no reference to 1st workbo 8
Macro copies values in other workbook 1
Hyperlink to another Workbook (97) 1
Copy Sheet to New File Without Code 5
mail merging 2 workbooks??? 21

Top