workbook lookup

[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

[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


--
Don Guillett
SalesAid Software
[email protected]
"Max_power" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>