Vlookup in Excel

Here is how we do Vlookup in Excel

Lets Say this is the Lookup table from where we want to get the Information

Name	Salary	Age
Robert	150000	25
Kevin	200000	30
John	100000	35
Smith	50000	26
Rose	75000	65
Shiela	250000	55

We want to get the Salary for following People

Name

Robert

Kevin

Leslie

The Vlookup formula will look like this

=VLOOKUP(G2,A1:C7,2,0)

Here Vlookup is the Function name

G2 - the column (Name) we are looking info about

A1:C7 - this is the range in excel where our lookup data is present

2 - to retrieve the second column information from Lookup table

0 - returns false if name doesn't exist

Result is

Name	Salary
Robert	150000
Kevin	200000
Leslie	#N/A