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

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

In this two-column lookup example, we will show you how to perform a two-column lookup in Excel. This is an easy way to find data quickly. We provide two examples below!

A two-column lookup is an excel function that helps you find information by entering the first few letters of your search term. You can use it on any type of spreadsheet and it's helpful for speeding up your workflow (and saving time!). Let's take a look at some examples of how to use two-column lookups!

We will be using the INDEX MATCH function to perform a two-column lookup in excel.

Let's learn the syntax of the MATCH function;

=MATCH(lookup_value, lookup_array ,match _type)

Lookup value - This can be a cell reference or text. In our two-column lookup example, we will use the first few letters of the name to look for it in an alphabetized list. Lookup array – The range that you want to match your lookup value with. Match type - this is where things get interesting! This tells Excel whether you are looking for an "exact" or a "close approximate".

Exact two-column lookups: If the two values are to be matched exactly, supply MATCH(lookup_value, lookup _array, 0)

In our two-column lookup example, we want to find the value in the "First Name" column that matches the value in the "Last Name" column. We will use MATCH(A12, A$11:A$22, 0). So, if you are looking for an exact match of two values in two columns, you would use 0 as your match type.

Follow the example of the Two-Column formula in excel in the above video.

Table Of Content 00:00 Introduction 00:29 Two-Column Lookup in Excel 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=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz ... https://www.youtube.com/watch?v=wcvJwy0t5WA