» Retrieving an Item from a List that Meets Multiple Criteria
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Business Analysis with Microsoft Excel (2nd Edition)
- Excel 2002 Power Programming with VBA
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Windows XP for Dummies
- Microsoft Excel 2002 Simply Visual
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
