| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Multiple Values from a variable table size
I Have the follwing arrray formula:
{=INDEX(Mes!$B:$B,SMALL(IF(Mes!$A$1:$A$13400=$M$1, ROW($1:$13400)),ROW(1:1)))} It works OK if the rows are always 13400 but if it grows or shrinks it wont work, how can I change the formula so that if the amount of rows changes it still gives me correct results? Thank You for your help. -- Gabriel Camarena R. Delphi Tijuana IT Support |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| multiple entries per cell to save on table size? | Excel Worksheet Functions | |||
| Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Excel multiple variable data table | Excel Discussion (Misc queries) | |||
Threaded Mode
