Need help for formula other than IF

[Cilukba]

Cheers Excel Lovers,

I have a problem with which formula to use,

The problem is I have a sales data and I am giving out bonus based on the performance. The data is simple,

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sales Peformance range A[/TD]
[TD]B[/TD]
[TD]Bonus[/TD]
[/TR]
[TR]
[TD]$0[/TD]
[TD]$250[/TD]
[TD]$50[/TD]
[/TR]
[TR]
[TD]$251[/TD]
[TD]$500[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]$501[/TD]
[TD]$750[/TD]
[TD]$150[/TD]
[/TR]
[TR]
[TD]$751[/TD]
[TD]$1000[/TD]
[TD]$200[/TD]
[/TR]
</tbody>[/TABLE]
and so on.

Lets say MR.A sales is $300 then the bonus is $100. It is very simple if i am using IF but the range goes on for about 20 rows. The list will be very long. I am thinking using vlookup but I do not think that would be the right choice.

Can anyone help me make it simpler ?

Regards

 

[sheetspread]

I am thinking using vlookup

You're right:

Excel 2010
	A	B
1	Sales Peformance range A	Bonus
2	0	$50
3	$251	$100
4	$501	$150
5	$751	$200
6
7
8
9
10	300	100
Sheet15

Cell Formulas
Range	Formula
B10	=VLOOKUP(A10,$A$2:$B$5,2,1)

 

[Cilukba]

You're right:


[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]=VLOOKUP(A10,$A$2:$B$5,2,1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Ah!... I got it now.. Thanks A Lot Mister....