T
TSulit
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
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