Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup doesn't work
I am unable to do a vlookup between different workbooks. I does however work
within the same workbook. Is their something I need to do to turn this functionality on. -- Thanks Michelle |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup doesn't work
It should work even if the other workbook is not open.
Your formula should look something like this if you used the other workbook to form the formula; =VLOOKUP(A1,[Book3]Sheet1!$A$1:$B$3,2,0) and something like this if you closed the other workbook; =VLOOKUP(A1,'C:\Documents and Settings\L. Howard Kittle\My Documents\Howard\[Book3.xls]Sheet1'!$A$1:$B$3,2,0) HTH Regards, Howard "mlhoward69" wrote in message ... I am unable to do a vlookup between different workbooks. I does however work within the same workbook. Is their something I need to do to turn this functionality on. -- Thanks Michelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
will vlookup work for me? | Excel Worksheet Functions | |||
VLOOKUP in 4 work sheets | Excel Worksheet Functions | |||
VLookup won't work | Excel Discussion (Misc queries) | |||
Countif + vLookup: Can they work together? | Excel Discussion (Misc queries) | |||
VLOOKUP won't work | Excel Worksheet Functions |