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