When you want to max out your look up skills then try this one, our lookup functions are explained on our training courses.
| Case Sensitive Reverse Lookup | ||||||||||||
| Word | Value | Word | Value | |||||||||
| 200 | CAt | CAt | 200 | |||||||||
| 300 | CAT | CAT | 300 | |||||||||
| 900 | Cat | Cat | 900 | |||||||||
| 500 | cat | cat | 500 | |||||||||
| 600 | caT | caT | 600 | |||||||||
| {=VLOOKUP($D9,IF(EXACT($D9,$B$5:$B$9),CHOOSE({1,2},$B$5:$B$9,$A$5:$A$9)),2,FALSE)} | ||||||||||||
| 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