Replacing Table_array to a cell content
 

I need to create a vlookup formula that replaces the table-array parameter to
be the contents of a cell

A1 contents D1:E10

vloopkup (a2,"contents of A1 above",1,0)

How do I do it?

thanks

Replacing Table_array to a cell content
 

=VLOOKUP(A2,INDIRECT(A1),1,0)

note that it is volatile


--
Regards,

Peo Sjoblom



"toolate88" wrote in message
...
I need to create a vlookup formula that replaces the table-array parameter
to
be the contents of a cell

A1 contents D1:E10

vloopkup (a2,"contents of A1 above",1,0)

How do I do it?

thanks

Replacing Table_array to a cell content
 

thanks

"Peo Sjoblom" wrote:

=VLOOKUP(A2,INDIRECT(A1),1,0)

note that it is volatile


--
Regards,

Peo Sjoblom



"toolate88" wrote in message
...
I need to create a vlookup formula that replaces the table-array parameter
to
be the contents of a cell

A1 contents D1:E10

vloopkup (a2,"contents of A1 above",1,0)

How do I do it?

thanks

Replacing Table_array to a cell content
 

"Peo Sjoblom" wrote...
=VLOOKUP(A2,INDIRECT(A1),1,0)

note that it is volatile
....

It take some work, but not a lot, for a nonvolatile work-alike. If there
were 29 or fewer ranges that would appear in A1, try a variation on

=VLOOKUP(A2,CHOOSE(MATCH(A1,{"G7:G12","G15:G20","H 7:H12","H15:H20"},0),
G7:G12,G15:G20,H7:H12,H15:H20),1,0)

This could bump into the limit on formula length.