| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine INDEX & LOOKUP?
Is there a way to combine these two functions where the last 2 parameters on
the index function are dependant on the value of cells in row 1 and col A?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine INDEX & LOOKUP?
It is a bit difficult to understand what you want but ...
maybe this could be of any help??? =INDEX('DATA'!1:65536;ROW();COLUMN()) HTH Sige |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Index Lookup | Excel Discussion (Misc queries) | |||
| ALLOW A REFERENCE IN "TABLE_ARRAY" POSITION OF LOOKUP & INDEX FUN. | Excel Worksheet Functions | |||
| Index table lookup anomaly | Excel Worksheet Functions | |||
| Lookup value in colA whos row matches row of index value in colB | Excel Worksheet Functions | |||
Hybrid Mode
