Excel Magic Trick 1391

Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup

DESCRIPTION

See how to create a formula to perform Case Sensitive Lookup:
(00:10) Introduction
(00:16) VLOOKUP by itself will NOT work.
(01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case Sensitive Lookup Value. Array Formula that does not require Ctrl + Shift + Enter.
(04:14) Formula #2: LOOKUP & EXACT functions to lookup Text Names based on a Case Sensitive Lookup Value. Array Formula that does not require Ctrl + Shift + Enter.
(07:03) Formula #3: LOOKUP & FIND functions to lookup Text Names based on a Case Sensitive Lookup Value. Array Formula that does not require Ctrl + Shift + Enter.
(09:14) Formula #4: VLOOKUP, CHOOSE & EXACT functions to lookup Text Names based on a Case Sensitive Lookup Value. Array Formula that DOES require Ctrl + Shift + Enter.
(11:41) Formula #5: INDEX, MATCH & FIND functions to lookup Text Names based on a Case Sensitive Lookup Value. Array Formula that DOES require Ctrl + Shift + Enter.
(12:55) List of functions in Excel that can perform Array Operations in Array Formulas that do NOT Require Ctrl + Shift + Enter.
(13:26) Timing of Formulas
(14:13) Summary

WORKBOOKS

Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 93 times – 3 MB







Be the first to comment

Leave a Reply