![]() |
#1
|
|||
|
|||
![]()
HI!
I am using this formula to look for 1 criteria, but I was wondering If it can be made to look for more that one. I uploaded an example. In the example I added the other criteria I want to look for =IF(ISERROR(INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$ E$1,ROW($A$1:$A$14)),ROW(1:1)),2)),"",INDEX($A$1:$ B$14,SMALL(IF($A$1:$A$14=$E$1,ROW($A$1:$A$14)),ROW (1:1)),2)) Thanks! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
![]() |
flds | Excel Programming | 5 | 09-30-2014 09:58 AM |
Ranking with multiple criteria | angie.chang | Excel | 0 | 08-14-2012 04:49 PM |
excel vlookup with multiple criteria | mpokorny | Excel | 4 | 05-06-2012 04:06 AM |
![]() |
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |