thanks "thard" for the explaination

:) much appreciated
--
oldLearner57


"thard" wrote:

I believe all you need to do is edit your formula to include the range
lookup, result should be =HLOOKUP(E5,C2:F3,2,FALSE)

If the range lookup is FALSE you will find an exact match on your lookup
value. If the range lookup is TRUE or omitted it will return an approximate
match to your lookup value.

Hope this helps

"tikchye_oldLearner57" wrote:

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