Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Name: Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.
Brand: Quizplus
Rating: 4.8 (42 reviews)

Question

Quizplus · Accepted Answer

There is no RLOOKUP function in Excel. It's a made-up function. The correct function for looking up the greatest value that does not exceed a specified value in a table or range is VLOOKUP with the "TRUE" as the fourth argument.

Unlike VLOOKUP, the RLOOKUP Function Looks Up the Greatest Value