Ask a New Question
Menu

Chocolate Cream filled

1.00


Strawberry

10.00


Kale frosted

6.00


Blueberry

3.00


Cream filled surprise

5.00













Based on the above table, you want to create a vlookup table. What would be the range of values that would return a value of purchasing a Kale frosted donut?

1 answer

To create a VLOOKUP table for the donut options you've provided, you need to identify the range of values that will return the price for a "Kale frosted" donut using the VLOOKUP function.

Assuming that your data is structured like this in a spreadsheet (for example, in Excel):

| A                   | B        |
|---------------------|----------|
| Donut Type          | Price    |
| Chocolate Cream filled| 1.00   |
| Strawberry          | 10.00    |
| Kale frosted        | 6.00     |
| Blueberry           | 3.00     |
| Cream filled surprise| 5.00     |

  1. Identify the Range: The range for the VLOOKUP function would include both columns (A and B) and all rows corresponding to the donut types and their prices. For the purpose of this example, let's say the data is in cells A1:B5.

  2. VLOOKUP Function: The VLOOKUP function in Excel is structured as follows:

    =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
    • lookup_value: The value you are looking for, which in this case would be “Kale frosted”.
    • table_array: The range of cells that contains the data (e.g., A1:B5).
    • col_index_num: The column number in the table from which to retrieve the value (in this case, 2 for the price).
    • range_lookup: TRUE for an approximate match or FALSE for an exact match. You would typically use FALSE for exact matches.

  3. Example VLOOKUP Formula:

    =VLOOKUP("Kale frosted", A1:B5, 2, FALSE)

This will return the price of the “Kale frosted” donut, which is 6.00.