Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below.
-One of Mark's co-workers asks what would happen if he changed the formula to one having a FALSE type. As an example for discussion, Mark writes: =VLOOKUP(Z10,H$1:I10,1,FALSE). How does the FALSE type affect this formula?
A) The VLOOKUP function looks only for an exact match of the lookup_value.
B) The VLOOKUP function looks only for negative values in the lookup_value.
C) The VLOOKUP function looks for the first value that is greater than the lookup_value.
D) The VLOOKUP function looks for the first value that is less than the lookup_value.

Question

Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below.
-One of Mark's co-workers asks what would happen if he changed the formula to one having a FALSE type. As an example for discussion, Mark writes: =VLOOKUP(Z10,H$1:I10,1,FALSE). How does the FALSE type affect this formula?
A) The VLOOKUP function looks only for an exact match of the lookup_value. 
B) The VLOOKUP function looks only for negative values in the lookup_value. 
C) The VLOOKUP function looks for the first value that is greater than the lookup_value. 
D) The VLOOKUP function looks for the first value that is less than the lookup_value.

Quizplus · Accepted Answer

When the FALSE type is used in the VLOOKUP function, it will only look for an exact match of the lookup_value in the range specified. If no exact match is found, it will return an error. This is different from using the TRUE type, which will return an approximate match if no exact match is found.

Mark Is in Charge of Determining the Unit Pricing for Each