Category: Formulas

How To Do A Case Sensitive Lookup

This formula will perform a vertical case sensitive lookup in a given range of values and return a result from the corresponding cell in another range. The functionality of this formula is similar to the VLOOKUP function, however VLOOKUP does not differentiate between upper and lower case letters when looking for a match. To VLOOKUP “AAA” and “aaa” would be the same thing.

Read More
Loading

Follow Us

Free Book

Recent Tweets

Categories

Pin It on Pinterest