Tom Urtis: Case-Sensitive VLOOKUP

VLOOKUP doesn’t care about upper or lower case. If you have ABC and Abc, VLOOKUP will see that as a match. In today’s article for VLOOKUP Week, Excel MVP Tom Urtis shows how to do a case-sensitive lookup. This is a great trick! Read Entire Article

VLOOKUP will never differentiate ATLAS from aTlas. Tom's formula can.

About Bill Jelen

Author of 41 books about Microsoft Excel. View all posts by Bill Jelen

One response to “Tom Urtis: Case-Sensitive VLOOKUP

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: