Nested IF(

[Squirt03]

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 exact match.
d. It is considered an approximate match.

I THINK THAT THE ANSWER IS C

[Squirt03]

I got it, the answer was D