Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |