cell value is the document name needed for vlookup

[davegk]

Greetings,

I'm trying to figure out if it's possible to create a vlookup formula that uses a cell's contents as the name of the document in the table array.

Example:
Cell A1 contains the text "mydocument.xls"
Cell A2 has a value of 500
Cell B2 has the formula: =VLOOKUP(A2,[mydocument.xls]Sheet1!$A:$B,2,FALSE)

I want to replace "mydocument.xls" in the vlookup formula with a reference to the content of cell A1, so that if I change cell A1 to "myotherdocument.xls" the vlookup formula will then search in that named document instead.

Is this possible?
Thanks!
-David

[oldchippy]

Hi,

Welcome to the forum, your in luck, your not the first to ask this question

http://en.allexperts.com/q/Excel-105...l-lookup-1.htm