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


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

No comments:

Post a Comment