Case Sensitive VLookup | |||||||||
Word | Value | Word | Value | ||||||
CAt | 200 | CAt | 200 | ||||||
CAT | 300 | CAT | 300 | ||||||
Cat | 900 | Cat | 900 | ||||||
cat | 500 | cat | 500 | ||||||
caT | 600 | caT | 600 | ||||||
{=VLOOKUP($D2,IF(EXACT($D2,$A$2:$A$10),$A$2:$B$10),2,0)} | |||||||||
Please be aware that it is an array formula so you need to use CTRL + SHIFT + ENTER keyboard shortcut. That's why there are braces around the formula. They appears after you typed CTRL + SHIFT + ENTER | |||||||||
Monday, 31 July 2017
Case Sensitive VLookup
Here is another one of our lookup Functions, this time adding if and exact to create a case sensitive VLookup how's that for a little magic
Labels:
Excel Functions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment