MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Looks up the greatest value that does not exceed a specified value anywhere in a table or range
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Question

Quizplus · Accepted Answer

The LOOKUP function is used to find the closest match to a given value in a set of data. It looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Answer: D
 The INDEX function is used to return a value or reference of the cell at the intersection of a specified row and column in a table or range.

Both functions can be used for looking up values in a table or range, but LOOKUP function returns the closest match while INDEX function returns the value at a specific position.

MATCHING Identify the Letter of the Choice That Best Matches the the Definition