# Looking at array to

#### btardo01

##### Board Regular
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

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Good afternoon. Just wanted to check in to see if anyone had any ideas on this one?

thanks

Replies
14
Views
277
Replies
1
Views
174
Replies
2
Views
106
Replies
5
Views
156
Replies
3
Views
267

1,203,241
Messages
6,054,322
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back