VLOOKUP
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) |
VLOOKUP
=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) |
VLOOKUP
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) |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com