VLOOKUP

S

Susan

Hello,

Is it possible to use an array from a different workbook? Getting error
messages when trying to add a workbook name to the formula below. Workbook
name trying to add is: VH TEST, Sheet1.
Do both workbooks need to be open when working?
Thank you,


=VLOOKUP(A1,$H$1:$I$3,2)
 
G

Gary''s Student

=VLOOKUP(A1,'C:\Documents and Settings\Owner\My Documents\[VH
TEST.xls]Sheet1'!$H$1:$I$3,2)


Take very careful note of the single quotes, the brackets, and the
exclamation mark.
 
S

Shane Devenshire

Hi Susan,

Rather than typing the formula open both workbooks then choose Window,
Arrange, Tile. Finally, create your formula by pointing and clicking, just
like you would if you were in one workbook.
 
Top