# 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.

### Example: Case Sensitive VLOOKUP in Google Sheets

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:

May 13, 2024
April 25, 2024
April 19, 2024
April 18, 2024
April 18, 2024

## One Reply to “How to Use a Case Sensitive VLOOKUP in Google Sheets”

1. bahar says:

hi 😊 please make it array, thank you!