Sequencing Formula

[mattyb1811]

Hi All,

Would someone please be able to advise the quick way to auto fill a column based on the below pattern?

=Sheet1!H3*Sheet2!B3
=Sheet1!I3*Sheet2!B4
=Sheet1!J3*Sheet2!B5
=Sheet1!K3*Sheet2!B6

New to this so apologise if vague or simple!

Thanks.

 

[Joe4]

Welcome to the Board!

What is the exact cell addresses these formulas are going in to?

 

[mattyb1811]

Thanks,

=Sheet1!H3*Sheet2!B3 into Sheet2!C3
=Sheet1!I3*Sheet2!B4 into Sheet2!C4
=Sheet1!J3*Sheet2!B5 into Sheet2!C5
=Sheet1!K3*Sheet2!B6 into Sheet2!C6

 

[Joe4]

OK, we can use the OFFSET function to do this.
Place this formula in C3 and copy down:

=OFFSET(Sheet1!$H$3,0,ROW()-3)*OFFSET(Sheet2!$B$3,ROW()-3,0)

 

[mattyb1811]

That's brilliant. Thanks a lot for your help!

 

[Joe4]

You are welcome!