VLOOKUP

Hi I am Safeer! I am student.

Safeermughal779@gmail.com

This is my email.you can connect with me with this email.

V LOOKUP:

              V LOOKUP in excel is useful for looking for specific information in your worksheet. The value you want to lookup also called the lookup value. The range where the lookup value is located. Remember that lookup value Should always be in first column in the range for v lookup to work correctly. For example, if your lookup value is in cell C2 then your range should start with C. 

USE  OF  V LOOKUP  FORMULA:

              Use lookup when lookup values are located in the first column of a table with information organized vertically. Use H LOOKUP when lookup values are located in the first row of the table, and each "record" appears in the new column. Range-lookup controls weather values need to match exactly or not.

How to use V LOOKUP Function in Excel:

    V LOOKUP is one of the excel most useful functions,and it's also one of the least understood.
V LOOKUP is an excel function. This article will assume that the reader already has a passing understanding of excel functions, and can use basic function such as Today, Sum and Average. In its most common usage, V LOOKUP is a database function, meaning that it works with database Tables or more simply, list of thing in excel Worksheet. What sort of thing? Well, any sort of thing. You may have a worksheet that contains a list of employees, or products, or customers, or CDs in your CD collection, or star in the night sky. It does not really matter 

What is exactly V lookup Function:

                                                  Basically, V Lookup let's you search for specific information in your spreadsheet. For example, if you have a list of products with price of a specific item. 

I am going to use to find the price of the photo frame. You can probably already see that the price is $9.99, but that's because this is a simple example. Once you learn, how to use V Look Up, you'll be able to use it with larger, more complex spreadsheet, and that's when it will become truly useful.

We'll add our formula to cell E2, you can add it to any blank cell. As with any formula, you'll star with equal sign(=). Then type the formula name. Our arguments will need to be in parenthesis, so type an open parenthesis. So far, it should look like this:

=V LOOKUP(

                          Adding the  Arguments

Now we'll add our arguments. The arguments will tell V LOOKUP what to search for and where to search.

The first argument is the name of item you are searching for, which in this case is photo frame. Because the arguments is text, We'll need to put it in double quotes:

=V LOOKUP("photo frame",A2:B16

Note: It's important to know that V LOOKUP will always search the firs column in this range. In this example, it will search column A for "photo frame". In some cases you need to move the column around so the first column contain he correct data.

The third argument is the column index number. It's simpler then it sounds: The firs column in the range is 1, the second column is 2, etc. In this case we are trying to find the Price of the Item, and the prices are contained in he second column. This mean our third argument is 2:

=V LOOKUP("photo frame",A2:B16,2

 The forth argument tells V LOOKUP whether to look for approximate matches,and it can be either True or False. If it is true, it will look for approximate matches. Generally, this is only useful if the firs column has numerical values that has been sorted. Because, we're only looking for exact matches, the fourth argument should be FALSE. This is our last argument, so go ahead and close the parenthesis. 

=V LOOKUP("photo frame",A2:B16,2,FALSE)

That's it! When you press enter, it should give you the answer, which is 9.99    

                                 How  it  works 

Let's take a look at how this formula works. It first Searches Vertically  down the first column (V LOOKUP is short for vertical lookup). when it finds "photo frame", it moves to the second column to find the price.