Monday 31 July 2017

Case Sensitive Reverse Lookup With Error Trap



Case Sensitive Reverse Lookup With Error Trap
Word Value Word Value
200 CAt bag come on a course and learn how its done
300 CAT CAT 300
900 Cat Cat 900
500 cat cat 500
600 caT caT 600
=IFERROR(VLOOKUP($D5,IF(EXACT($D5,$B$5:$B$9),CHOOSE({1,2},$B$5:$B$9,$A$5:$A$9)),2,FALSE),
"come on a course and learn how its done")}
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