Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. If you omit the range_lookup value from a LOOKUP function, which of the following is true?
A)The function returns the #NAME? error value.
B)Your function can only search the first column of the lookup table.
C)It is considered an approximate match.
D)It is considered an exact match.

Question

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​If you omit the range_lookup value from a LOOKUP function, which of the following is true?
A)The function returns the #NAME? error value.
B)Your function can only search the first column of the lookup table.
C)It is considered an approximate match.
D)It is considered an exact match.

Quizplus · Accepted Answer

When the range_lookup value is omitted, it is considered an approximate match. This means that the LOOKUP function will search for the closest match in the first column of the lookup table, rather than requiring an exact match.

Case-Based Critical Thinking Questions Case 8-3 You Have Been Using