» 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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Marketing Plan: A Handbook with Marketing Plan
- Microsoft Excel 2002 Formulas (With CD-ROM)
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.

