Thanks Ken. It works great for my example, but I should have made my example
closer to my actual problem. Lets move cell A1 to a different sheet. The
value of A1 also references a range in a completely different workbook. I
can't get INDIRECT to accept this. Thanks again.

" wrote:

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