| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
![Harlan Grove[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
