Hi
Cell A1:2007Rates.xls
How can I use the fileneme in cell A1 in a Vlookup Formula.
Instead of:
=VLOOKUP(E10,[2007Rates.xls]lookup_table!$A:$B,2,FALSE)
I want to say:
=VLOOKUP(E10,[A1]lookup_table!$A:$B,2,FALSE)
So that I can change the name in Cell A1, and the lookup will refer to a different workbook
Thanks
Richard
Bookmarks