Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to use a case-sensitive vlookup in Google Sheets.
How to Use a Case-Sensitive VLOOKUP in Google Sheets
The VLOOKUP function is a powerful tool in Google Sheets, allowing you to quickly and easily look up values in a table. By default, VLOOKUP is case insensitive, meaning it treats upper and lower case letters the same.
However, there may be times when you need to perform a case-sensitive VLOOKUP. For example, you may have a list of names and email addresses, and you want to make sure the email addresses are in the correct case.
For these situations, we can use the INDEX and MATCH functions instead. The INDEX and MATCH function allows us to use the EXACT function as well, which will only return a value if it has the exact case as a specified string.
In this guide, we will show you how to use a case-sensitive VLOOKUP in Google Sheets.
How to Perform a Case-Sensitive VLOOKUP in Google Sheets
Here’s our step-by-step guide on how to perform a case-sensitive vlookup in Google Sheets.
First, select an empty cell where you want to place the formula.
In the example above, we want to take a given last name in cell E1 and lookup the corresponding email address in the lookup table in columns A and B.
We’ll start by typing the INDEX function. Add the range you want to find the lookup value as the first argument.
Next, we’ll use the MATCH and EXACT functions as our second argument. The formula =INDEX(B2:B101, MATCH(TRUE, EXACT(E1, A2:A101), 0)) will allow us to perform a case-sensitive lookup of a given value.
If no matches are found, the formula will output a #N/A error.
This guide should be everything you need to learn how to use a case sensitive vlookup in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.