» Retrieve Value Using Case-Sensitive Lookups
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: 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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Not-for-Profit Accounting Made Easy
- Analyzing Markets, Products, and Marketing Plans
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Understanding Financial Statements
No comments have been submitted.

