The MATCH and INDEX functions can be used to overcome the data range limitations of the VLOOKUP and HLOOKUP functions.
Correct Answer:
Verified
Q38: All of the following statements are TRUE
Q39: All of the following statements are TRUE
Q40: In the VLOOKUP function below,which of the
Q41: The IF function can employ other logical
Q42: A nested IF requires one or more
Q44: The DSUM function is a database function
Q45: The NEVER function allows creation of logical
Q46: The ability to use MATCH and INDEX
Q47: At least one logical test must be
Q48: Outline-code uses the structure of functions but
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