Register now or log in to join your professional community.
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!
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:
Last argument is used for exact match or approx match.use0 or false for exact match and1 or true for approx match.
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.
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