Sum Value Multiplied by Look up from multiple column data

[Mike Brewer]

Hello, please see example sheet attached. Update:....... Sorry...file now uploaded

On sheet 1 I'm trying to calculate the row in column D where the row in column C has no value present.
To do this I need to use the reference in column A to look up the corresponding column on sheet 2 and return the last number in that column. This value is then multiplied by the corresponding row in sheet 1.

The answer is hard typed in Sheet 1 D9 and is arrived at by multiplying Sheet 1 B9 by Sheet 2 D5

...and I just can't work out how to do it, so any assistance gratefully received

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[Mike Brewer]

Thank you yes it says scroll down to 'GO ADVANCED' ...i scroll down but cannot see that button anywhere?

[Abith]

your query seems fairly easy but without a sample we wont be able to give you the proper solution

[Mike Brewer]

Thanks Abith, unfortunately I am unable to get any information on why I do not have the 'GO ADVANCED' link which apparently will enable me to add the attachment. When I create a new post the only options I have are 'Review Post' and 'Submit new thread'. I'm not sure why my system is not showing what is described in the instruction at the top of the page.... frustrating

[JeteMc]

The .txt file attached to post #1 simply repeats the text of post #1.
Please attach the Excel file that has Sheet1 and Sheet2 as referred to in post #1.
Let us know if you have any questions.