=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.
--
Gary''s Student - gsnu200837


"Susan" wrote:

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)