The ____ function looks up the greatest value that does not exceed a specified value anywhere in a table or range.
A) HLOOKUP
B) VLOOKUP
C) LOOKUP
D) all of the above

Question

Quizplus · Accepted Answer

The LOOKUP function is the best choice because it returns the closest match to the lookup value that does not exceed it. HLOOKUP and VLOOKUP are more specific functions that search for a value in a particular row or column.

The ____ Function Looks Up the Greatest Value That Does