How can we use vlookup in excel

Then type the formula name. Our arguments will need to be in parentheses, so type an open parenthesis. So far, it should look like this:. Now, we'll add our arguments. The first argument is the name of the item you're searching for, which in this case is Photo frame.

Because the argument is text, we'll need to put it in double quotes:. The second argument is the cell range that contains the data. In this example, our data is in A2:B As with any function, you'll need to use a comma to separate each argument:. In this example, it will search column A for "Photo frame". The value that it returns in this case, the price will always need to be to the right of that column. The third argument is the column index number.

It's simpler than it sounds: The first 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 the second column. This means our third argument will be 2 :.

Excel Usage notes. Map text to numbers. This formula uses the value in cell F7 for a lookup value, the range B6:C10 for the lookup table, the number 2 to indicate "2nd column", and zero as the last argument to force an exact match. Although in this case we Map inputs to arbitrary values. This formula uses the value in cell F6 for a lookup value, the range B5:C10 for the lookup table, 2 to indicate "2nd column", and zero as the last argument to force an exact match.

Although in this case we are mapping Group times into unequal buckets. If you need to group times into buckets that are not the same size i. The problem There are several ways to group times in In this example, the goal is to retrieve employee information from a table using only a partial match on the last name. In other words, by typing "Aya" into cell H4, the formula should retrieve information about Michael The goal in this example is to create a self-contained lookup formula to assign a grade to the score in cell E7, based on the table in B6:C It requires a table with lookup values in this case, dates to the left of the values being retrieved.

The lookup value comes from cell E6, which must be a valid date. The table In other words, we want a formula that allows us to switch tables dynamically based on a user-supplied value. There are The workbook exists in the same directory and the data in the file looks like If you know the name of a product, for instance, and you want to quickly determine its price, simply enter the product name into Excel and VLOOKUP will find the price for you.

Specify the cell in which you will enter the value whose data you're looking for. In this case, we've selected the entire table excluding the headers.

Enter the value whose data you're searching for.