software

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 quot;update valuesquot; 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: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=530415You 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

quot;Max_powerquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I was wondering why certain lookups that I am performing won't function
gt; properly. I have say workbook1 and I want to do a lookup in workbook2
gt; but when I click on workbook2 the lookup won't work ie I get the
gt; message quot;update valuesquot; for workbook.
gt; It was working before but just doesn't work now, anyone have any
gt; ideas?
gt; So I have something like
gt; =VLOOKUP(A2,'[WORKBOOK2.XLS]SHEET1'!B:B,1,FALSE)
gt;
gt; Many thanks
gt;
gt;
gt; --
gt; Max_power
gt; ------------------------------------------------------------------------
gt; Max_power's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32255
gt; View this thread: www.excelforum.com/showthread...hreadid=530415
gt;