Case sensitive lookups.
Listed in Range A11:B13 are characters and their corresponding codes.
Upper case and lower case forms of the same letter are assigned two different codes.
How could we find the exact code in Range A2:B7 matching each character in Range A11:B13?
Use the EXACT function to determine whether one of the characters in Range A2:B7 matches exactly (case sensitive) to the lookup character in Range A11:B13.
Then, providing an identical chahrcter was found in Range A2:B7, use the INDEX and MATCH functions to retrieve the code corresponding to that character.
Following is the combined Array Formula:
(To create Array formula: select the cell after typing the formula,press F2 and then press Ctrl+Shift+Enter)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1