» Retrieve Value Using Case-Sensitive Lookups

Problem:

Listed in the range A2:B7 are characters and their corresponding ASCII codes.
Not that upper and lower case forms of the same letter are assigned different codes.
We want to be able to find the code from 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))}


Example:
Range1

Character_________Code
A_________________65
a_________________97
B_________________66
b_________________98
C_________________67
c_________________99

Range2

Character______Code
A______________65
b______________98
C______________67

Screenshot // Retrieve Value Using Case-Sensitive Lookups