Microsoft Excel

Learn How to Perform Case Sensitive Lookup in Microsoft Excel

Learn How to Perform Case Sensitive Lookup in Microsoft Excel

The main purpose of this formula is to perform a case-sensitive lookup. Here we will learn how to perform the case-sensitive lookup in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the EXACT, INDEX, and MATCH functions, you can able to perform a case-sensitive lookup.

So, with the help of this formula, you can able to perform a case-sensitive lookup in the given data range in the workbook in Microsoft Excel.

 

General Formula to Perform Case Sensitive Lookup 

=INDEX(range1,MATCH(TRUE,EXACT(A1,range2),0))

 

The Explanation to Perform Case Sensitive Lookup

Learn How to Perform Case Sensitive Lookup in Microsoft Excel

So we know that with the help of the given formula above, you can able to perform a case-sensitive lookup. Here we will learn how to perform the case-sensitive lookup in the given data range in the workbook in Microsoft Excel.

As we know, the INDEX and MATCH formula is at the core of this formula, with the EXACT function used inside MATCH to perform a case-sensitive match.

When working from the inside-out, the EXACT function is configured to compare the value in E5 against names in the B column. So now you have learned how to perform a case-sensitive lookup in the given data range in the workbook in Microsoft Excel.