Dynamic VLOOKUP

[wmcnabb084]

It's budget time and I need to be able to do a VLOOKUP into several hundred workbooks and populate a summary page based on criteria from a dropdown list. My basic VLOOKUP is in the form of:

=VLOOKUP(C3,'[ALDERSON EAST FIELD - Budget Year - 2013.xlsm]Summary Page'!$J$13:$O$29,3,FALSE)

The only part that has to dynamically change is the workbook name and not the sheet reference so in this case:

[ALDERSON EAST FIELD - Budget Year - 2013.xlsm]

Any suggestions would be greatly appreciated.

Wyatt

 

[Aladin Akyurek]

It's budget time and I need to be able to do a VLOOKUP into several hundred workbooks and populate a summary page based on criteria from a dropdown list. My basic VLOOKUP is in the form of:

=VLOOKUP(C3,'[ALDERSON EAST FIELD - Budget Year - 2013.xlsm]Summary Page'!$J$13:$O$29,3,FALSE)

The only part that has to dynamically change is the workbook name and not the sheet reference so in this case:

[ALDERSON EAST FIELD - Budget Year - 2013.xlsm]

Any suggestions would be greatly appreciated.

Wyatt

If the target books can be open at the time of retrieval, have a look at the INDIRECT function. If you need to work with closed workbooks, uou can install the morefunc.xll add-in a 32bit system and invoke the INDIRECT.EXT function.

 

[wmcnabb084]

If the target books can be open at the time of retrieval, have a look at the INDIRECT function. If you need to work with closed workbooks, uou can install the morefunc.xll add-in a 32bit system and invoke the INDIRECT.EXT function.

Sorry do not have admin rights on this machine so cannot instal any addins...

 

[Aladin Akyurek]

Sorry do not have admin rights on this machine so cannot instal any addins...

Try to locate the PULL function by Harlan Grove and see you can use it.