Is there a way to have a filename in a formula changed dependant upon the contents of another cell?? The formula is as follows:
=VLOOKUP(C5,'2004.csv'!$A$1:$B$3472,2)
i need to be able to change the 2004.csv, i can go through and do this manually, but i want to have a cell where the user can enter the year and it will select the correct filename.i.e. 2003 would lookup 2003.csv.
Regards
Glenn
=VLOOKUP(C5,'2004.csv'!$A$1:$B$3472,2)
i need to be able to change the 2004.csv, i can go through and do this manually, but i want to have a cell where the user can enter the year and it will select the correct filename.i.e. 2003 would lookup 2003.csv.
Regards
Glenn