| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index and match formulas
Assuming your data starts in A1, enter this formula:
=IF(ISERROR(INDEX($B$1:$B$7,SMALL(IF($E$1:$E$7=30, ROW($E$1:$E$7)),ROW(1:1)))),"",INDEX($B$1:$B$7,SMA LL(IF($E$1:$E$7=30,ROW($E$1:$E$7)),ROW(1:1)))) Enter it as an array formula, using Conrol Shift and Enter. Copy down as far as your data goes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up, match index? multi variable formulas | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| "Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas | Excel Worksheet Functions | |||
| how to start using vlookup, match & index formulas, examples | Excel Worksheet Functions | |||
| index/ match formulas orice | Excel Worksheet Functions | |||
Threaded Mode
