Learn more:- https://www.exceltutorial.net/

Lookup Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimXjKB1EOoRWznYZtqRe7B2z

Our VLOOKUP function is a great tool for performing case-insensitive lookups in Excel. However, if we need to perform a case-sensitive lookup, other functions will help us do this. 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!

First, we will discover the limitation of VLOOKUP when it comes to case sensitivity, as we know VLOOKUP's syntax is; V

LOOKUP(Lookup_value, Table_array, Col_index_num, [Range_lookup]). We know that the lookup value and table array are not case-sensitive. So if we have a list of data that is in lowercase letters and we perform a VLOOKUP on it with an uppercase lookup value, it won't return anything because it's not looking in the correct column.

Next we will look at how to use INDEX and MATCH with EXACT to do a case-sensitive lookup. INDEX and MATCH can be used together to find data in a table based on two criteria: the row number and the column number. The syntax for INDEX and MATCH is;

INDEX(Array, Row_num, Column_num)

MATCH(Lookup value, Lookup array (column), Match type). We use the row number because we want our data to be in order by case sensitivity. For example: if we have a list of data that has both uppercase and lowercase letters, we want our VLOOKUP to look in the correct column based on case.

Lastly, we will discover how to use INDEX with MATCH together so you can get an exact match between two columns of data. We need to do this because if there are duplicate values in another column, VLOOKUP won't be able to find the data we're looking for. The syntax for this is;

INDEX(Array, Row_num, Column_num)

MATCH(Lookup value, Lookup array (column), Match type). In our example, we will have a list of data that has both lowercase and uppercase letters. We will have a list of data that has just lowercase letters, but VLOOKUP won't be able to find the matching data because it's case-sensitive. This is where INDEX with MATCH comes in!

Table Of Content 00:00 Introduction 00:32 VLOOKUP Limitation with Case-sensitive 02:40 Perform a Case-Sensitive Lookup 05:00 Conclusion

Other Playlists:-

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw ... https://www.youtube.com/watch?v=681QtrB_D68