Pick a percentage from a range

[johnrobgray]

Hi there

I'm struggling with this one. I'm trying to get excel to choose a percentage based on a result (this is for a multiplier for performance)

Your Target	Your Result	Reward Multiplier
74.00%	74.00%

This is what I have in my sheet and in multiplier I want it to choose from the list below

85.00%​	110.00%​
80.00%​	105.00%​
74.00%​	100.00%​
68.00%​	90.00%​
0-67.99%	80.00%​

So in the example above, 74% would deliver 100%

How can I enter the formula so that it changes based on the numbers delivered to fit within the range?

Thanks in advance

 

[GWteB]

How about ...

Book1
	A	B	C	D	E	F	G
1	target	result	reward		min	max	reward
2	74.00%	74.00%	100.00%		0.00%	67.99%	80.00%
3					68.00%	73.99%	90.00%
4					74.00%	79.99%	100.00%
5					80.00%	84.99%	105.00%
6					85.00%	100.00%	110.00%
Sheet1

Cell Formulas
Range	Formula
C2	C2	=VLOOKUP(B2,E2:G6,3)

 

[johnrobgray]

Thank you so much, this worked a treat

 

[GWteB]

Glad to help and thanks for letting me know