| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX useing Dynamic Range
I want to use INDEX with one part of the lookup range as a dynamic address
that I generate in a series of cells i.e. MATCH(xxxx:A14093,278,3) I cant get it to work because if the generated address such as A984 is created in cell M1 and I put M1 were the xxxx is, the range interpreted by MATCH is M1:A14093 not my desired A984:A14093. If I use INDIRECT(M1) I get the contents of A984 not the address A984. Any help will be much appreciated. Vic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range Within INDEX | Excel Discussion (Misc queries) | |||
| Dynamic Index() or Vlookup() | Excel Worksheet Functions | |||
| Dynamic Range Using INDEX instead of Offset | Excel Discussion (Misc queries) | |||
| dynamic table_array in lookup,match & index | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Threaded Mode
