lookup

[Kinghart]

can anyone help me with this.... I'm attaching a sample worksheet...

[NBVC]

Please explain in more detail within the post too.. so people can decide if they want to look into your file or not... and also helps future users to narrow down their own search results.

Also save the file as .xls as not many have XL2007 yet.

[JBeaucaire]

Your formula works fine, your ranges in A17:A19 are off by one level.

Change them to:

Please Login or Register  to view this content.

[Kinghart]

Your formula works fine, your ranges in A17:A19 are off by one level.

Change them to:

Please Login or Register  to view this content.

No... Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49

[Kinghart]

No... Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49

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…

[Max, Singapore]

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))

Try in C7, normal ENTER:
=INDEX($B$17:$I$19,MATCH(TRUE,INDEX(B3<=$A$17:$A$19,),0),MATCH(F3,$B$16:$I$16,0))

[Kinghart]

Try in C7, normal ENTER:
=INDEX($B$17:$I$19,MATCH(TRUE,INDEX(B3<=$A$17:$A$19,),0),MATCH(F3,$B$16:$I$16,0))

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

[Kinghart]

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

Sorry And Thanks Bro.... It seems to be working perfectly.. my mistake :-)

[Max, Singapore]

Nope... that works for the values below 0.5 but not greater than 1... example 1.2

But it works fine in your sample when I tested it out??
With B3 containing eg: 1.2, F3: g, C7 returned: 44

Actually A17:A19 is 0.00-0.49, 0.50-0.99, 1.00-1.49

If you have since changed the rules as depicted in your earlier sample
to the above, why don't you just try changing A17:A19 to reflect your new limits: 0.49, 0.99, 1.49