March 27, 2012

Tom Urtis: Case-Sensitive VLOOKUP

By Bill Jelen

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

Case Matters

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

This entry was posted on Tuesday, March 27th, 2012 at 06:13 and tagged with Case, EXACT, INDEX, MATCH and posted in Advanced VLookup Information. You can follow any responses to this entry through the RSS 2.0 feed.

One response to “Tom Urtis: Case-Sensitive VLOOKUP”

VLOOKUP Week Wraps Up: Vote For Your Favored Publish – Microsoft Windows 8
April 6th, 2012 at 03:02

[…] =INDEX(MATCH(Exact for case delicate lookup from Tom Urtis […]

Reply

Leave a comment Cancel reply