Vlookup(lookup_value)

[Guest]

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

 

[arno]

Hi,

I think, INDIRECT does not work over workbooks.

arno