» 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:
- The New Financial Order: Risk in the Twenty-First Century
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
No comments have been submitted.
