Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?
A) HLOOKUP(lookup_value, table_array, row_index_num)
B) MATCH(lookup_value, lookup_array, match_type)
C) INDEX(array, row_num, col_num)
D) VLOOKUP(lookup_value, table_array, col_index_num)
Correct Answer:
Verified
Q30: A positive NPV means that the investment
Q31: The easiest way to locate a particular
Q32: Identify the equation for calculating the
Q33: For which of the following MATCH functions
Q34: Explain the different Lookup functions in Excel.
Q35: In a MATCH function, if the match_type
Q36: In a MATCH function, the default value
Q37: Use the following scenario to answer
Q38: Give the logical function for the following:
Q39: Which of the following functions is 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