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

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

In this video, we will talk about LEFT Lookup in excel. By Default, The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left, simply use INDEX and MATCH. This is helpful when you need to get values from different columns or rows that are not adjacent on your worksheet!

We will use the combination of the INDEX & MATCH function in excel to find values on the left as we have described in the video. Let's see how INDEX MATCH works;

The INDEX function takes two arguments: the row number and the column number. The MATCH function, on the other hand, takes three arguments: lookup value, table array, and column index. So in our example below we are looking for the value "Apple" in Column A and returning the corresponding value from Column B which is "15".

An example of INDEX MATCH is below;

=INDEX(B:B,MATCH("Apple",A:A,0))

Browse through the timeline below to watch the video;

Table Of Content 00:00 Introduction 00:23 Left Lookup Using INDEX MATCH Formula 02:40 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=wOLqcPRImnw