amarbhagwat
New Member
- Joined
- Jun 14, 2013
- Messages
- 2
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
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