Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Why we are use vlookup in excel and why this is important in excel?

user-image
Question added by pravitha nottath , Customer Service Representative , Tanfeeth enbd.group
Date Posted: 2013/11/18
Deleted user
by Deleted user

it minimises typographical error and time. Vlookup and Hlookup is very useful if one several data are link to one or more sheets. Try it!

Shahnawaz Alam Shahnawaz
by Shahnawaz Alam Shahnawaz , Database Specialist , Intigral

Excel is used for find value in table array. It is very useful function for matching two data base on common value. Suppose you have thousand of order details in which you  have to find few hundred order in master data weather these are exit in your master order data or not.

Further you have only only order ID and you want to get all details agains order easly you can get using vlookup

Syntax

Vlookup(lookup Value,lookup table array, column index number,0)

Explaination

lookup value -- Value which you want to find

lookup table array -- Table in which value to be search

column Index number -- The column index number indicates which column of the table array contains the data you are after.

For example:

    • if you enter a2 into the column index number, VLOOKUP returns a value from the second column of the table_array;

 

  • if the column index number is4, it returns a value from the fourth column of the table_array.

Last argument is used for exact match or approx match.use0 or false for exact match and1 or true for approx match.

Vlookup

 

 

 

sheharyar ameen
by sheharyar ameen , Technical Account Manager , KSB Pumps Company Limited

because in excel, we can calculate,can make charts , can do analysis,can make spread sheet ETC. inshort can do any type work. and specially every type of person like, businees man,engineer,acountant ,doctor , in stores and labortary ETC. excel is helpful. means one software solve the proble in every field.

NIZAMUDEEN KABEER
by NIZAMUDEEN KABEER , IT INFRA Cloud , Tata Communications

ecel is excellent work sheet because it will do for  each every cell will work for as calculation ,progress also very easy to mange of excl sheet .accounting ,word processing ect very easy catregrised 

 

More Questions Like This