# Complex Calculation Formula (Complex to me anyway)

#### SDowse

##### Board Regular
Hi,

I have a spreadsheet with 2 sheets, with information in the first few columns followed by dates.

What I am looking to do is multiply a value in sheet1 by an amount looked up in sheet2, but for a specific month.

So, Sheet 1 has columns A - D with Tier1, Tier2, Tier3 and Tier4...followed by Jan13 - Dec 13 (on row 11). The rows below have numbers in 1 or more of the columns.

Sheet 2 has column A with Tier1, Tier2 etc...in rows from A11 downwards, then months across from B11 onwards (Jan to Dec 13).

What I want to do is, for row 12 for example, look up the value in Sheet1 A12 and times it by the value for Tier1 on sheet 2 for that month...so A12 says 30, in E12 (under Jan13) put the value of 30 times whatever is in Jan13 on sheet2 for Tier1...the problem is there could be a value in 1 or more of the columns on sheet1, so it would need to look at each column and do the calculation.

Does that make sense?

Simon

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Replies
8
Views
270
Replies
30
Views
502
Replies
2
Views
211
Replies
3
Views
126
Replies
6
Views
284

1,195,680
Messages
6,011,122
Members
441,586
Latest member
rodsin76

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