Learning Excel , V lookup

Do you know about  MS EXCEL ? if yes then great but for newbies i would like to write few lines about it first ! So, Excel is an application which has features like calculation, graphic tools, pivot charts and micro programing (VB). Microsoft excel provides special features to present data in smart way, with ease of work. Professional has to work smartly to manage the work load & to convert data in to information.

Here i am  going to teach you about some uncommon tools and some daily use tools for MS Ecxel. 

V lookup:

What is V lookup in excel ? 

This function is used to stack of number‘s in to a desired information. One can easily find data from vertically align tables, which associated with the value entered by the user.

Now we want some specific information from the below mentioned table, we want to find the price in the new spread sheet. We want to search the price of “Air Conditioners” in the below table.  

 

Now we will add our formula in cell H2, you can add it to any other cell or any other spread sheet.

Steps:

1-      Start the formula with sign (=), type the formula name.

2-      Adding Arguments:

a.       Add the first argument in the formula, our argument is “Air Conditioners”, e.g =vlooup(“Air Conditioners”.

b.       Now add 2^nd arguments it is, the range of data “A2:B:20”,                                                       e.g =vlookup(“Air Conditioners”,A2:B20. Note: the vlookup will always search the 1^st column in this range, check the formulas before moving the columns.

c.       The 3^rd argument is the coloumn index number, The 1^st columns in the range is 1 and the 2ns is 2. In this case we have to fine the price of the products so our index columns will be 2, e.g =vlookup(“Air Conditioners”,A2:B20,2

 

d.       The 4^th argument will be to look for “approximate matches or exact matches”, it can be True or False. If you enter True it will search for approximate match and if enter  False it search ofr exact match it. In this case we looked for exact match so enter false and close the parenthesis. e.g  =vlookup(“Air Conditioners”,A2:B20,2,false.

                                and the answer will apper when you will press the enter.

Thank you for reading. What i need you is your comments and sharing ! should you have any questions ? feel free to ask me right here! 

Happy Excel 

NoMan!