Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-14-2015, 06:49 PM
piper7971 piper7971 is offline how to look up for multiple criteria Windows Vista how to look up for multiple criteria Office 2007
Advanced Beginner
how to look up for multiple criteria
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to look up for multiple criteria I need to add multiple values based on multiple criteria in a cell not sure what to do AUHAMM Excel 3 10-27-2014 09:11 PM
how to look up for multiple criteria Copy Multiple Rows to new workbook when multiple criteria is met. 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
how to look up for multiple criteria Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft