In the previous post, we saw ‘Lookup & Reference | How to Use Excel Transpose Function?, now we will learn about How to Use Excel VLOOKUP Function?’.
Where to Find the Lookup & Reference Function?
To find the Lookup & Reference function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Lookup & Reference’ option as shown below:
You can also see the Lookup & Reference function via shortcut key – press ‘ALT + M + O’ after that select the lookup & Reference function that you want to use.
What is Excel VLOOKUP Function?
The Excel Vlookup function searches for a value in first column of a data/table_array and if it’s found, it returns a corresponding value from the same row but another column.
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
The VLOOKUP function syntax has the following argument:
lookup_value: Lookup value is the value we need to search
table_array: Table array is a rectangular array of data where we need to search the lookup value.
col_index_num: Col_index_ num is the column number belonging to the same table array, from which a corresponding value needs to be retrieved.
All these three arguments are mandatory
range_lookup: Final argument is range lookup, which is an optional argument. It asks for true or false, true meaning approximate matching of lookup value and false meaning exact matching of lookup values.
Understand With Example
In this example with help of ID we need to find salary of employee.
To do that in cell I5 type =VLOOKUP(G5,A5:E12,4,FALSE) in cell G5 type the id of the employee.
For Latest Updates & Learning Join Our YouTube Channel: Join Now