How to do Case Sensitive Lookup in Excel

The excel’s VLOOKUP function isn’t case sensitive and they will return the fist matched value from the list. INDEX-MATCH is no exception but it ...

17 Things About Excel VLOOKUP

Introduction to VLOOKUP Function The VLOOKUP function in Excel is without a doubt is most used and talked function. In any job interview that require...

How to Get Position of First Partial Match

In this article, we will try to get position of first partial match in a range. As we know that MATCH function returns the index or position of fi...

Use VLOOKUP from Two or More Lookup Tables

Imagine, you have two tables of students. You want to do a lookup for Kyle in table1. If he’s not found in table1, you would want to search in the o...

How To Look Up Address in Excel

In this article, we will learn how to retrieve cell address of a lookup value. There will be times when you would want to get address of cell from ...

How to Get All Matches in Different Columns

This article will talk about how to get all values matched from a table and retrieve them in different cells. This is similar to lookup multiple v...

How to Retrieve Latest Price in Excel

Let’s say you maintain data of different items in a list. The latest price of an item can be found by looking last entry of that item. So, if your...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube