Variable file names in a Vlookup

[kosciosco]

Here is one no one seems to be able to answer and I don't think it is possible.

I am creating a table which consists of Vlookups. Each line of the table links to a different file. Here is a rough idea of the table.

A B C D
1 Jan Feb Mar
2 Firm AA
3 Firm BB
4 Firm CC



The file name of each line is "Firm AA Revenue.xls" and the next one "Firm BB Revenue.xls", etc

What I would like to be able to do is a vlookup like this:

=Vlookup(B$1,$A2&" Revenue.xls'!$A$1:$B$10",2,False)

(I hope you get the gist)

Anyway, this won't work, so does anyone know a way to do it?

Thanks

Simon

[windknife]

Try this,

Please Login or Register  to view this content.

HTH,
windknife