LinkBack URL
About LinkBacks
No... Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49Originally Posted by JBeaucaire
Your formula works fine, your ranges in A17:A19 are off by one level.
Change them to:
A17=0 A18=.5 A19=1
No... Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49Your formula works fine, your ranges in A17:A19 are off by one level.
Change them to:
A17=0 A18=.5 A19=1
Sorry about that...
Here's what I want excel to do for me….
I want the final result (in which I want the formula to be) in cell c7 (as in the attached sheet)
first I want to match the text in f3 from the table
next I want to match the value in b3 and display the value in c7
I'm usuin a formula like this:
INDEX($B$17:$I$19,MATCH(B3,$A$17:$A$19,-1),MATCH(F3,$B$16:$I$16,0))
But an not getting what I want…
Try in C7, normal ENTER:first I want to match the text in f3 from the table
next I want to match the value in b3 and display the value in c7
I'm using a formula like this:
INDEX($B$17:$I$19,MATCH(B3,$A$17:$A$19,-1),MATCH(F3,$B$16:$I$16,0))
=INDEX($B$17:$I$19,MATCH(TRUE,INDEX(B3<=$A$17:$A$19,),0),MATCH(F3,$B$16:$I$16,0))
Max
Singapore
Nope... that works for the values below 0.5 but not greater than 1... example 1.2
Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49
Edit/Delete Message
Last edited by Kinghart; 11-29-2008 at 07:47 AM.
Sorry And Thanks Bro.... It seems to be working perfectly.. my mistake :-)
But it works fine in your sample when I tested it out??Nope... that works for the values below 0.5 but not greater than 1... example 1.2
With B3 containing eg: 1.2, F3: g, C7 returned: 44
If you have since changed the rules as depicted in your earlier sampleActually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49
to the above, why don't you just try changing A17:A19 to reflect your new limits: 0.49, 0.99, 1.49
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks