Good afternoon everyone, i hope you can help.

I have a workbook that uses vlookups to return values from another file. What i want to be able to do is change that file based upon the selection from a combo box. i know i have done this is thepast but cant for the life of me remember how i did it.

my current formula is:
=vlookup(AB2,'C:\TEMP\Chris\[PRV_Car_2009_5+7.xls]Monthly'!$A$7:$N$18,5,0)

i basically want to be able to change the 5+7 part of the file name somehow so it will look at a different file based upon the selection made.

Hope that makes sense.

Thanks

EddiesVoicebox

I think you're looking for the INDIRECT function.