» Retrieving an Item from a List that Meets Multiple Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Range A2:C7 contains a list of items and their corresponding colors and prices.
We want to find the name of the first Blue item that costs less than $200.
Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(1,(B2:B7=D2)*(C2:C7
Example:
Item______Color____Price___Criteria
Shoes_____Red______$140____Blue
Jacket____Brown____$300____$200
Shoes_____Blue_____$199
T-Shirt___Green____$10
Jeans_____Blue_____$150
Shoes_____Black____$99
Result_____Shoes
Book Store:
Recommended Books:
- How to Pay Zero Taxes (Annual)
- Getting to Yes: Negotiating Agreement Without Giving In
- Special Edition Using Microsoft Outlook 2002
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
No comments have been submitted.
