good morning:
I have a file, on sheet1, in column A is a list of 8 employees. On sheet1, column F there is a calculated allocation of each employee's salary. On sheet2, column B there is a full list of 30 employees. and in the next column is a bonus % that each employee is eligible for.
I'd like to have a formula on sheet 1, cell c2 that looks up the bonus %, from sheet2, of each employee listed on Sheet 1 and multiplies it by their allocated salary. This formula would just give one total of all.
So for example,
Sheet 1 list
Bob Smith, 60,000
Chris Jones, 55,000
Sheet 2 shows Bob's bonus % at 5%
and Chris's bonus % at 10%
The formula would use the employee list on sheet 1 to look up the % on sheet two and give me result of (60,000*5%) + (55,000*10%) = 8,500
Appreciate your help.
I have a file, on sheet1, in column A is a list of 8 employees. On sheet1, column F there is a calculated allocation of each employee's salary. On sheet2, column B there is a full list of 30 employees. and in the next column is a bonus % that each employee is eligible for.
I'd like to have a formula on sheet 1, cell c2 that looks up the bonus %, from sheet2, of each employee listed on Sheet 1 and multiplies it by their allocated salary. This formula would just give one total of all.
So for example,
Sheet 1 list
Bob Smith, 60,000
Chris Jones, 55,000
Sheet 2 shows Bob's bonus % at 5%
and Chris's bonus % at 10%
The formula would use the employee list on sheet 1 to look up the % on sheet two and give me result of (60,000*5%) + (55,000*10%) = 8,500
Appreciate your help.
