hello community
I setted up a table in this manner:

col = B C D E F
Row = 2 Mark 100 90 80 70
3 Grade a b c d
4
5 Mark 100
6 Grade d (lookup
result base on E5)

when I use the =hlookup(E5,C2:F3,2), I have the Grade = "d" ? can community

help to explain to me what is happening to my "hlookup()" ?

thanks community for explaining

:)




--
oldLearner57