A problem similar to one I just posted

I have a spreadsheet that is designed to collate results from other individual spreadsheets in the same directory using the VOOKUP command

e.g.

=VLOOKUP($A7,'C:\Merits\[Maths.xls]Nominations'!$A$6:$T$2000,19,FALSE)
However each cell needs to cross-reference a different column

e.g. sometimes I might want to use the one above, other times I might want to do

=VLOOKUP($A7,'C:\Merits\[Sciences.xls]Nominations'!$A$6:$T$2000,19,FALSE)
The subject (e.g. Maths, Sciences) whose name needs to come before the ".xls" is stored in cell (e.g.) F6

Is there a way that I modify the code above so that it automatically creates the filename

'C:\Merits\[whatever is in cell F6].xls'