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 |
Vlookup(lookup_value)
Hi,
I think, INDIRECT does not work over workbooks. arno |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com