Need solution for my problem ( Excel Formula )

[amarbhagwat]

Hi Experts

This is my first post so apology if i have done any mistake while posting the thread.

I am looking for an excel formula to get the result. Data is provided in below table

There are 3 criteria based on which a single value needs to pick automatically.

criteria 1 = value 1 variable e.g 92.5%
criteria 2 = value 2 variable e.g. 32%
criteria 3 = value 3 variable e.g. 27.5 year

I need a formula which will give me answer by considering all three criteria

[TABLE="width: 500"]
<tbody>[TR]
[TD]value 1[/TD]
[TD]value 2[/TD]
[TD]value 3[/TD]
[TD]answer ( formula)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]criteria C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]criteria a[/TD]
[TD]criteria B[/TD]
[TD]25.1 to 30 Years[/TD]
[TD]25 Years or less[/TD]
[/TR]
[TR]
[TD]95.01% and above[/TD]
[TD]35[/TD]
[TD]0.96[/TD]
[TD]0.85[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]30[/TD]
[TD]0.84[/TD]
[TD]0.73[/TD]
[/TR]
[TR]
[TD]95% to 90.01 %[/TD]
[TD]30[/TD]
[TD]0.78[/TD]
[TD]0.67[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]25[/TD]
[TD]0.67[/TD]
[TD]0.56[/TD]
[/TR]
[TR]
[TD]90% to 85.01[/TD]
[TD]30[/TD]
[TD]0.60[/TD]
[TD]0.49[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]25[/TD]
[TD]0.52[/TD]
[TD]0.41[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]20[/TD]
[TD]0.42[/TD]
[TD]0.31[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12[/TD]
[TD]0.34[/TD]
[TD]0.23[/TD]
[/TR]
[TR]
[TD]85% and under[/TD]
[TD]25[/TD]
[TD]0.43[/TD]
[TD]0.32[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]20[/TD]
[TD]0.39[/TD]
[TD]0.28[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12[/TD]
[TD]0.32[/TD]
[TD]0.21[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]06[/TD]
[TD]0.27[/TD]
[TD]0.19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Your expert help is really helpful. I have tried the fusion of lookup with index function but my efforts were went into vain.

Regards

Amar

 

[Rick Rothstein]

Thanks for clarifying, Rick.
Was the keystroke always working this way? I always thought it was just deleting.

I don't know for sure, but it works in XL2003 (the earliest version of Excel that I have). I was vaguely aware of this short-cut before, but I never use it... I prefer CTRL+X/CTRL+V (I mistakenly wrote CTRL+C instead of CTRL+X in my previous message) as that is what I use throughout my Windows programs. My guess is the SHIFT was supposed to be a mnemonic aid of some sort indicating you can "shift" location after the "delete".

 

[ZAX]

I think ZAX was surprised to find that selecting a cell, then pressing the SHIFT-DELETE key combination (from your posted name "shift-del(ete)"), then selecting a different cell and then pressing the Enter key moves the value in the cell in the same way that pressing CTRL+C, selecting a different cell and then pressing CTRL+V does. I think it was a new key combination for him.

Mister Rick is right,It's a new combination to me and worked as clarified (by him) on Excel 2003 and I didn't know it,If any one could help me remember the combination (as far as I remember) to auto fill the cell with the keyboard!?
ZAX