Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup
I have this to be a problem also. If you reformat in ascending order ie...70
80 90 100 etc.. and re-try I think you will find that it will solve the problem if you use: =HLOOKUP(e5,C2:f3,2,TRUE) Alternatively you can use: =INDEX(C2:f3,2,MATCH(C5,C2:f2,0)) 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup
thanks "Nav" for the explaination much appreaciated :)
-- oldLearner57 "Nav" wrote: I have this to be a problem also. If you reformat in ascending order ie...70 80 90 100 etc.. and re-try I think you will find that it will solve the problem if you use: =HLOOKUP(e5,C2:f3,2,TRUE) Alternatively you can use: =INDEX(C2:f3,2,MATCH(C5,C2:f2,0)) 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and hlookup | Excel Worksheet Functions | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Index / Hlookup | Excel Worksheet Functions | |||
Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions |