How to Use a Case Sensitive VLOOKUP in Google Sheets

You can use the following basic formula to perform a case sensitive VLOOKUP in Google Sheets:

=INDEX(B2:B10, MATCH(TRUE, EXACT(G2, A2:A10), 0))

This particular formula finds the exact value in cell G2 in the range A2:A10 and returns the corresponding value in the range B2:B10.

The following example shows how to use this formula in practice.

Suppose we have the following dataset that shows the number of sales made by various salesmen at a company:

Now suppose we attempt to use the following VLOOKUP formula to look up “Andy” and return his number of sales:

=VLOOKUP(D2, A2:B10, 2)

This formula incorrectly returns the number of sales for ANDY instead of Andy:

Instead, we need to use the following formula that can perform a case-sensitive VLOOKUP:

=INDEX(B2:B10, MATCH(TRUE, EXACT(G2, A2:A10), 0))

This formula correctly returns the number of sales for Andy, which turns out to be 29:

The formula correctly returns the number of sales for Andy instead of ANDY.

The following tutorials explain how to perform other common operations in Google Sheets: