Thread: Replacing Table_array to a cell content
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
toolate88 toolate88 is offline
external usenet poster
  
Posts: 3
Default 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



Reply With QuoteReply With Quote