G
Guest
What's wrong with this formula:
=vlookup(I2,[PLLIST.xls]Sheet1!$a$2:$c$500,3,False)
Where I2 is the cell that is being looked up
PLLIST is the workbook where the table is located (in the same directory as
the file I'm working on)
Sheet1 is the sheet in that workbook
The lookup range is a2:C500
The information that I want in my cell is from column 3 in PLLIST, which is
not in numerical order (False)
As best I can tell, the error is in referencing another workbook.
Thanks for any help.
KK
=vlookup(I2,[PLLIST.xls]Sheet1!$a$2:$c$500,3,False)
Where I2 is the cell that is being looked up
PLLIST is the workbook where the table is located (in the same directory as
the file I'm working on)
Sheet1 is the sheet in that workbook
The lookup range is a2:C500
The information that I want in my cell is from column 3 in PLLIST, which is
not in numerical order (False)
As best I can tell, the error is in referencing another workbook.
Thanks for any help.
KK