Replacing Table_array to a cell content

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Peo Sjoblom said:
=VLOOKUP(A2,INDIRECT(A1),1,0)

note that it is volatile
Click to expand...
....

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","H7:H12","H15:H20"},0),
G7:G12,G15:G20,H7:H12,H15:H20),1,0)

This could bump into the limit on formula length.
 
Back
Top