hi community

when i created a table horizontally, a value from Ascending scale...
example:

mark: 0 30 40 60 80 90
grade F E D C B A

and when I used the =hlookup to find the approximate mark say, 85, I able to
obtain "B"

however when I reverse the mark to Descending scale...
and use the same hlookup method with 85 I obtain an "F"

is there a way to find the correct grade if I place the mark in Descending
scale ??

thanks community for help render :)

--
oldLearner57