Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

Case-sensitive Lookup in Excel

Admin
Duration: 5:25
Submitted: 3 months ago
Views: 141

Comments (0)

Link to this video:

Description: If you need to do a case-sensitive lookup in Excel, there are a few different functions that you can use. In this video, we'll go over 3 ways you can use INDEX and MATCH with EXACT to find data in your spreadsheet by doing a case-sensitive lookup! Table Of Content 00:00 Introduction 00:32 VLOOKUP Limitation with Case-sensitive 02:40 Perform a Case-Sensitive Lookup 05:00 Conclusion The VLOOKUP function in Excel is a great tool for performing case-insensitive lookups. However, if we need to perform a case-sensitive lookup, the INDEX and MATCH functions can help us do this. These functions allow us to specify that we want our lookup to be case-sensitive, so that we can match data accurately. In this tutorial, we'll go over three different examples of ways you can use INDEX and MATCH with EXACT to do a case-sensitive lookup. We will use three main functions for the case sensitive lookup namely, INDEX, MATCH and EXACT Function in excel. The INDEX function takes a given range and returns the value at the intersection of a row and column. The MATCH function takes two arguments: the first is the value we're looking for, and the second is the range in which we're searching. The EXACT function checks if two strings are exactly equal. We'll use these functions to create a case-sensitive lookup in Excel. In the first example, we'll use the INDEX and MATCH functions together to find a value in a range. We'll use the EXACT function to make sure that our values are matched exactly. In the second example, we'll use the INDEX function to find a value in a range. We'll use the MATCH function to do the lookup, and we'll specify that it is case-sensitive by using EXACT as well. In our final example, we'll combine all three of these functions together for another way to perform a case-sensitive lookup using INDEX and MATCH with EXACT. We'll start with a very simple example of how we can use INDEX and MATCH together to find the value at a row and column intersection within a range in Excel. If you need to do a case-sensitive lookup in Excel, the INDEX and MATCH functions can help you do this. These functions allow us to specify that we want our lookup to be case-sensitive, so that we can match data accurately. In this tutorial, we've gone over three different examples of how you can use these functions together to perform a case-sensitive lookup. We've used the INDEX function, the MATCH function and the EXACT function in excel to create our case-sensitive lookups. Each example showed how these functions can be combined in different ways to achieve a desired outcome. With a little experimentation, you should be able to find the combination that works best for your own needs!