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?
Many thanks in advance,
Simon
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?
Many thanks in advance,
Simon