LOOKUP ?? Referencing Grades in a Table to use within the calculation

[HelenL]

Hi Excel Geni
I am trying to calculate the Annual Estimate by multiplying the Grade 'percentage equivalent' by the Annual Amount using the equivalent Grade amount quoted in a small table within the spreadsheet. Any ideas please? Thank you!

	Grade	Bonus Rate
	1	10%
	2	10%
	3	15%
	4	20%
	5	20%
	6	25%
	7	27%
	8	30%
Monthly amount	Grade	Status	Start Date	Annual Amount	Annual Estimate
5000	8	Current	01/05/2013	60,000.00	6,000
6000	8	Current		72,000.00	7,200
3000	7	Current		36,000.00	3,600
2500	7	Current		30,000.00	3,000

<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>

 

[LxQ]

So, let's say the word "Grade" is in B1, then the grades would be in B2 through B9, and the percentages would be in C2 through C9..
in the table below, the 8 under "Grade" would fall in B12, and the $60,000 under "Annual Amount" would be in E12.. then your formula would be:

=E12*VLOOKUP(B12,B2:C9,2)

 

[HelenL]

thank you, worked a treat