Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup(lookup_value)
I want to pass a named range (e.g.- alookup which names cells A21:A46)
to the 1st argument in VLookup(lookup_value, ....) I know I am able to pass a named range (e.g.- Adata which names cells $A$19:$H$40) to the 2nd argument in VLookup(..,table_array...) Basically, i want to see the difference between identical cells from 2 different wksheets within the same workbook. The formula looks something like this: =VLOOKUP($A5,$A$3:$H$24,2,FALSE)-VLOOKUP(ExampleSheet1!$A21,INDIRECT("'["&$A$50&".xls]"&$A$51&"'!"&$A$53),2,FALSE) The user provides the following: Cell a50-wkbook name Cell a51-starting lookup_value Cell a52-table_array name |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup(lookup_value)
Hi,
I think, INDIRECT does not work over workbooks. arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple lookup_value | Excel Discussion (Misc queries) | |||
VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) | Excel Worksheet Functions | |||
vlookup:same lookup_value, different returns | Excel Worksheet Functions | |||
VLOOKUP - dealing with lookup_value differences | Excel Worksheet Functions | |||
Next largest value that is greater than lookup_value. | Excel Worksheet Functions |