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 IDs. The formula you need is:
=INDEX(B1:B5;SUMPRODUCT((EXACT(A1:A5;E2))*(ROW(A1:A5)));1)
