i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value
i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value
VLOOKUP() will not do what you want. You can use MATCH() and INDEX(), if the
list is sorted in descending order and you use -1 as the 3rd argument in the
MATCH() function
"vlookup help pls" wrote:
> i cant get vlookup to select the closest value if the closest value is higher
> it automatically selects the highest value below the cell value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks