| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Try this... {=INDEX('E373'!$T$1:$T$2000,SMALL(IF(('E373'!$Y$1: $Y$2000='STATUS SHEET'!B3)*('E373'!$Q$1:$Q$2000="CCYI"),ROW('E373' !$T$1:$T$2000),IF(('E373'!$Y$1: $Y$2000='STATUS SHEET'!B3)*('E373'!$Q$1:$Q$2000="CCYV"),ROW('E373' !$T$1:$T$2000))),ROW('E373'!$T$1:$T$2000)))} It is not as nice as an OR statement, but it should receive the same result. -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=319918 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use array formula for three variables? | Excel Discussion (Misc queries) | |||
| Array formula weird result | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
| SUM array formula question | Excel Worksheet Functions | |||
Threaded Mode
