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

Multiple Choice

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.