Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. A25 contains a value that will find a match in the table. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return, a product number or product price?

Answer 1

The formula =VLOOKUP(A25,A2:B20,2,FALSE) will return a product price.

Here's a breakdown of the formula:

• A25 is the lookup value; it contains the product number you want to find in the table.
• A2:B20 is the range of the table where the lookup is performed. In this case, column A has the product numbers, and column B has the product prices.
• 2 indicates that the formula should return the value from the second column of the specified range, which is column B (the prices).
• FALSE specifies that the function should find an exact match for the lookup value.

In summary, this VLOOKUP function searches for the product number in column A and returns the corresponding product price from column B.