Thread: [Solved] how to look up for multiple criteria
View Single Post
 
Old 06-14-2015, 06:49 PM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
  
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default how to look up for multiple criteria
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!
Attached Files
File Type: xlsx Copy of eImagine-Excel-Multiple-Matches.xlsx (16.4 KB, 27 views)
Reply With Quote