>> vlookup refering to a cell to get wookbook name

[Jonathan]

Hi, using Excel 2003. Is it possible to have a vlookup have the name of a
workbook containing the range to lookup (2nd argument) in another cell?
Something like the following...

=vlookup(a4,"[" & c1 & .xls]Sheet1!$B$11:$D$200,3,FALSE)

c1 contains a workbook name.

Any ideas or suggestions appreciated

 

[Bob Phillips]

You can use

=VLOOKUP(A4,INDIRECT("'[" & C1 & ".xls]Sheet1'!$B$11:$D$200"),3,FALSE)

but the other workbook must be open.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)