| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| replacing numbers in a cell | Excel Worksheet Functions | |||
| How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions | |||
| In VLOOKUP how to pick Table_array value from a cell | Excel Worksheet Functions | |||
| In VLOOKUP how to pick Table_array value from a cell | Excel Worksheet Functions | |||
Linear Mode
