» Retrieving the Price for a Specified Item and a Specified Brand
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: Retrieving the matching price of the item shown in cell A2, for the specific brand entered in cell B2.
Following are the prices for each possible combination:
Item,Brand,Price
Jeans, Diesel, $85
Jeans, Levis, $80
Jeans, Lee, $70
T-Shirt, Sacks, $7
T-Shirt, Gap, $5
T-Shirt, Old Navy, $3
Solution:
Use the IF and LOOKUP functions as shown in the following formula:
=IF(A2="Jeans",LOOKUP(B2,{"Diesel","Lee","Levis";85,70,80}),IF(A2="T-Shirt",LOOKUP(B2,{"Gap","Old Navy","Sacks"},{5,3,7})))
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Wall Street Journal Guide to Understanding Money and Investing
- Not-for-Profit Accounting Made Easy
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Marketing Planning for Services
- Business Plans Kit for Dummies (With CD-ROM)
No comments have been submitted.
