CATEGORY: Lookup Formulas VERSIONS: 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

Rate this tip 1 2 3 4 5   RATING: 2.22   VIEWS: 7685 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

How to Use Financial Statements: A Guide to Understanding the Numbers Not-for-Profit Accounting Made Easy The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition Windows XP for Dummies Getting to Yes: Negotiating Agreement Without Giving In Investments + S&P Card + Powerweb + StockTrak discount coupon

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books