Which of the following is not one of the required arguments for a VLOOKUP function
A) The lookup table range
B) The value you want to compare to the values in the left column of the table
C) The index of the column you want the returned value to come from
D) TRUE (for an approximate match) or FALSE (for an exact match)

Question

Which of the following is not one of the required arguments for a VLOOKUP function
A) The lookup table range 
B) The value you want to compare to the values in the left column of the table 
C) The index of the column you want the returned value to come from 
D) TRUE (for an approximate match) or FALSE (for an exact match)

Quizplus · Accepted Answer

The TRUE or FALSE argument is optional in the VLOOKUP function; if omitted, it defaults to TRUE for an approximate match.

Which of the Following Is Not One of the Required