Vlookup(lookup_value)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top