Tag Archives: lookup

Three different ways to do case-sensitive lookup

Posted on April 9, 2016 by MF

If you do VLOOKUP, you probably know that one of the limitations of VLOOKUP is case-insensitive.  It means case is not a consideration in the lookup process, where PETER is essentially the same as peter. Hence VLOOKUP will consider that … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 3 Comments

Date Formats – A trick to format date with “st”, “nd”, “rd”, “th”

Posted on November 8, 2014 by MF

Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 17 Comments

Perform VLOOKUP with 2 lookup values

Posted on May 11, 2014 by MF

4 different ways to perform LOOKUP with 2 lookup values We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; VLOOKUP only handle one … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 38 Comments

How to lookup only partially-matched value?? – Crazy lookup!!!

Posted on January 23, 2014 by MF

This is a real workplace problem. Look at the two tables below, the task was to map the Shop ID from Table 1 (left) to Table 2 (right).  In both tables there is a common key “Shop Name”.  Sound easy? … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | Leave a comment