VLookup Range Help
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
|