Ken,
That works for me too as long as Book 2 is open. If I close Book 2 and
replace A1 with the full path name to Book 2 (C:\Book 2) then it gives a
#REF!. Any ideas?
-Chris

" wrote:

Chris

The same methodology still works for me when I have:

=VLOOKUP(B1,INDIRECT(Sheet2!A1),1,FALSE)

in cell C1 on sheet1 of Book1

and

[Book2]Sheet1!$A$1:$A$10

in A1 of sheet2 of Book1

and my lookup range on Sheet1 of Book2.

Ken





On Jun 8, 11:21 am, JE McGimpsey wrote:
One way:

A2: =VLOOKUP(1, INDIRECT(A1),1, TRUE)

In article ,



CWillis wrote:
I would like to have the "Range" portion of the VLOOKUP command be populated
from a user input. Is this possible?

Ex: A2 has the formula VLOOKUP(1,A4:C12,1,TRUE) works. Instead, I would
like for cell A1 to have the value: "A4:C12" and the formula in A2 to be
VLOOKUP(1,A1,1,TRUE). I would like to avoid macros.

Thanks in advance.

-Chris- Hide quoted text -

- Show quoted text -