Lookup & Reference | How to Use Excel VLOOKUP Function?



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?

Advertisements

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.


Syntax

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])


Arguments

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.

excel vlookup

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

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock