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