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

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

The VLOOKUP function in excel is a very important formula for data analysis and reporting. It is a function that returns values from the specified range in the table. We have categorized this video into 6 different parts with different scenarios, vlookup also return values matching wild card character such as asterisk, in any row or column. The default value of VLOOKUP is the closest match which is useful if you need to calculate the percentage of the total bill for customer but it has one major drawback which cannot look up values on the left side of the column.

Lets Look at the syntax of VLOOKUP;

=VLOOKUP([lookup_value], [table_array], [col_index_num], [range_ lookup])

[lookup_value] : The value to be looked up. This can be a value or text and the vlookup function will find an exact match, if it exists

[table_array] : The range of cells where we have data arranged in rows and columns format (a table). It does not include any blank rows between two records

[col_index_num] : column number from the left side of vlookup function searches for data. If you want vlookup to start searching from second column, enter two here

[range_lookup] : this is optional argument that specifies whether a value between 0 and FALSE will be treated as a approximate match if no exact match exists; TRUE or omitted will treat a value of 0 or FALSE as an exact match, and omit any approximate matches.

What vlookup actually does? It returns a value from the same row in one array based on a search value in another array. This function is almost similar to index & Match functions but it has some unique advantages which we have listed below:

VLOOKUP can return text or numbers based on the value you enter

It does not require to specify the position of vlookup formula in a worksheet because it will automatically search from left side and vlookup always returns an exact match. If no exact match exists, vlookup function searches for an approximate match. It has one major drawback which is it cannot look up values to the left of a column.

VLOOKUP can be used in combination with other excel functions such as INDEX, MATCH and IFERROR

You can use vlookup function in any worksheet of your workbook including the summary sheet.

This was all about vlookup function in excel, we hope that you would have liked our detailed explanation with examples. In case of any doubt or query, feel free to post them in the comment section below and we will get back to you as soon as possible. Till then Happy vlookup-ing!

In the next videos, we w ... https://www.youtube.com/watch?v=9yd-6sM7riA