can anyone help me with this.... I'm attaching a sample worksheet...
can anyone help me with this.... I'm attaching a sample worksheet...
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.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
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
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)
Bookmarks