You Have Been Using a Variety of Nested IF Functions

Multiple Choice

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.