| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup table_array
Hi,
Use indirect =VLOOKUP(2,INDIRECT(C1),2,FALSE) Where c1 is your table name Mike "A" wrote: Hi all my vlookup formula uses a named range (eg keep in the formula below) as the table array. Is there any way of putting the name of the range as text in cell A2 and linking A2 in the vlookup? =VLOOKUP(A1,keep,2,FALSE) =VLOOKUP(A1,?+A2?,2,FALSE) Thanks Ade |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup table_array
Thanks for the quick response Mike
"Mike H" wrote: Hi, Use indirect =VLOOKUP(2,INDIRECT(C1),2,FALSE) Where c1 is your table name Mike "A" wrote: Hi all my vlookup formula uses a named range (eg keep in the formula below) as the table array. Is there any way of putting the name of the range as text in cell A2 and linking A2 in the vlookup? =VLOOKUP(A1,keep,2,FALSE) =VLOOKUP(A1,?+A2?,2,FALSE) Thanks Ade |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with dynamic table_array | Excel Worksheet Functions | |||
| Vlookup with function in table_array | Excel Worksheet Functions | |||
| VLOOKUP TABLE_ARRAY | Excel Worksheet Functions | |||
| vlookup with table_array constructed from mid formula | Excel Worksheet Functions | |||
| vlookup template -> table_array | Excel Worksheet Functions | |||
Hybrid Mode
