=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