Loop this formula?

Hi, just wondering is it possible to create a loop for this formula?

Formula:

=IF(B3=Sheet2!A2,C3*Sheet2!B2



=IF(B4=Sheet2!A2,C4*Sheet2!B2



=IF(B5=Sheet2!A2,C5*Sheet2!B2

Basically its in every cell, I add 1 to C, so it keeps going, C6, C7, C8, C9, etc?