Hi,
I have an HLookup that is supposed to return a grade based on the lookup value. Think A = 90 (and above), B = 80 (and above), etc.
I know that if I have these values ascending, I will be able to use a vlookup or hlookup to return the correct grade depending on how the table is oriented, but for very specific reasons that I won't delve into, the values need to be descending.
Is there any way to return the correct grade using a different function or is there some sort of workaround?
Thank you !!!!
Bookmarks