Results based on targets

[Helix242]

Hi,

I hope someone can help. I am trying to create a formula to yield a set result based on the figure of once cell, and I can't seem to get anywhere with this. Here is what the figures are:

(Column A) (Column B)

Products sold Amount paid
<15 £0
15-19 £50
20-24 £100
25-29 £150
30+ £200

I am aware that the If(OR formula may work, but I am at a lose, any help would be appreciated. Many thanks in advance!

Many thanks

Mark

 

[oldbrewer]

Products sold Amount paid								mytable
<15 £0
15-19 £50										0	0
20-24 £100									15	50
25-29 £150									20	100
30+ £200										25	150
										30	200
				col E
				prods sold	paid
		row 11		3	0	#####
				14	0
				15	50
				19	50
				20	100
				23	100
				25	150
				35	200
				150	200
				2500	200
				#####
				=VLOOKUP(E11,mytable,2)

<colgroup><col span="15"></colgroup><tbody>
</tbody>

 

[Helix242]

Products sold Amount paid								mytable
<15 £0
15-19 £50										0	0
20-24 £100									15	50
25-29 £150									20	100
30+ £200										25	150
										30	200
				col E
				prods sold	paid
		row 11		3	0	#####
				14	0
				15	50
				19	50
				20	100
				23	100
				25	150
				35	200
				150	200
				2500	200
				#####
				=VLOOKUP(E11,mytable,2)

<tbody>
</tbody>

Hi,

Thanks for this, however I am unable to get this to work using the lookup formula. I have the correct table entry, but the 2 at the end is somewhat confusing.

I will have the total number of products sold, and would require the outcome (about paid) to be listed below that, but I cannot get your formula to work.

Please could you help?

Many thanks

Mark

 

[Helix242]

Hi,

Thanks for this, however I am unable to get this to work using the lookup formula. I have the correct table entry, but the 2 at the end is somewhat confusing.

I will have the total number of products sold, and would require the outcome (about paid) to be listed below that, but I cannot get your formula to work.

Please could you help?

Many thanks

Mark

Hi,

Finally figured out your formula. . Thanks for your help.

Many thanks

Mark

 

[oldbrewer]

the 2 at the end is the second column in the look up table - glad to help