Chris

Try something like:

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

with the range of interest in cell A1, e.g. A4:C12.

Good luck.

Ken
Norfolk, Va


On Jun 8, 10:57 am, 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