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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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)