In a FALSE VLOOKUP, if an exact match is not found, ____ is returned.
A) an error value
B) an approximate match
C) the first value in the column
D) the last value in the column
Correct Answer:
Verified
Q37: Excel provides nine functions, called the OF
Q38: In VLOOKUP, if a type FALSE is
Q39: You use VLOOKUP when _ of the
Q40: The syntax of the INDEX function is
Q41: In a VLOOKUP function, the argument _
Q43: To return a negative value, _ is
Q44: When creating a range for use with
Q45: A VLOOKUP table can have _ key
Q46: When solving an HLOOKUP formula, Excel looks
Q47: To find and retrieve data from a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents