Lookup Function in Excel

Basically Lookup function use on when you want to find some Product name in a table by some unique ID or number. For example, look up a salary of an employee by his employee code number, or find an employee name based on their mobile Number.

I think all are familiar with lookup function name. Now a day 3 type of lookup function use in industries. His name is
1) VLookup,
2) Hlookup and last one is
3) XLookup.

Now let’s talk on VLOOKUP function. This most common and most use excel function in IT or Data Industries. First we know string of VLOOKUP.
=vlookup(lookup_value,table_array,col_index_num,range_array)

1) Lookup_value Means “What value you want to look up” is called the lookup value.
2) Table array Means “Where you want to look for it” The range where the lookup value is located. like Different sheet and Colum name.
3) Col_index_num Means “The column number in the containing range the value to return”
4) Range_array Means “Return an Approximate or Exact match – Know as 1 is TRUE and 0 is FALSE“

Now let’s move on example,

Ok lets talk on above example, here we select heel as a lookup value an we want to heel salary from big amount of data. So lets start
First type “=VLOOKUP(B11 (Heel lookup value) , B1:E8 (select column till salary because we want to employee salary), col_count (employee salary is in the column se we type 4 in formula, make sure col_count start form next to lookup value, and then last select 0 because “0” indicate exact match and 1 is indicate match with approx.

ok so formula is =VLOOKUP(B11,B1:E8,4,0) Enter.