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


--
Don Guillett
SalesAid Software

"Max_power" wrote in
message ...

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


--
Max_power
------------------------------------------------------------------------
Max_power's Profile:
http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=530415