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)