» Retrieve Value Using Case-Sensitive Lookups
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Listed in the range A2:B7 are characters and their corresponding ASCII codes.
Note that upper and lower case forms of the same letter are assigned different codes.
We want to be able to find the code from cells B2:B7 that provides a case-sensitive match for each character in cells A11:A13.
Solution:
Use the INDEX, MATCH, and EXACT functions as shown in the following Array formula:
{=INDEX($B$2:$B$7,MATCH(TRUE,EXACT(A11,$A$2:$A$7),0))}
Book Store:
Recommended Books:
- Special Edition Using Microsoft Word 2002
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Marketing Management
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Mortgages For Dummies®
No comments have been submitted.

