Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,2,FALSE)

Answer 1

The price for the product found in column A (or the closest product if the exact product number cannot be found)

Answer 2

The price for the product found in column A (or #N/A if the exact product number cannot be found)

Answer 3

The product # for the product in column A (or #N/A if the exact product number cannot be found)

Answer 4

Don’t know

Answer 5

The product # for the product in column A (or #N/A if the exact product number cannot be found)

Answer 6

The price for the product found in column A (or #N/A if the exact product number cannot be found)

Answer 7

The price for the product found in column A (or the closest product if the exact product number cannot be found)

Answer 8

Don’t know

Answer 9

The product # for the product in column A (or the closest product if the exact product number cannot be found)

Answer 10

The price for the product found in column A (or #N/A if the exact product number cannot be found)

Answer 11

The price for the product found in column A (or the closest product if the exact product number cannot be found)

Answer 12

Don’t know

Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,1,FALSE)