In this Excel tutorial you will learn how to do case sensitive lookup.

The problem is that your data differ only by case so capitalization is important for you. That's why you need case sensitive lookup. Let's construct a formula which will solve your problem. INDEX formula suits the best. Syntax here will be:

**=INDEX(value_you_need, row_number, column_number)**

**value_you_need**is a data range from your data table**row_number**- this is hard to get. You have to use EXACT function for case sensitive function**column_number**is always 1

In this example you need the **Price** and you have **Product ID**s. The formula you need is:

=INDEX(B1:B5;SUMPRODUCT((EXACT(A1:A5;E2))*(ROW(A1:A5)));1)