VLOOKUP (IS_SORTED FALSE/TRUE)
We need to provide 4 arguments for the VLOOKUP function.
Which value we’re looking for?
Which column of the selected range do we want to return?
Type FALSE for an exact match or TRUE for an approximate search.
Here, the search range is sorted.
Type TRUE.
We search for 5.
The formula returns the code of number 4.
Because the selected value doesn’t exist, and the nearest value to it is 4.
