VBA - Inserting a formula on next row

[LittleJon]

I am trying to get some VBA code, that will insert a formula in the next available row in Column I.

The formula needs to match the contents of Column C and O in that row with the cells in the row above and return with the contents of the cell above.

I hope you can see the image i've tried to link.

In this case, the VBA code would insert a formula into Column I row 8, the formula will see the company name in Column C row 8 and the 1st line of the address in Column O row 8, it would then check if the contents of the cells above (Column C & Column O Row 7) are a match and would then put in the same 3rd party reference as Column I row 7.

What would be the best formula for this, nested IF or IF AND?

Any help would be appreciated.

www.imageupload.co.uk/images/2018/10/15/Londonpods.png" border="0"></a>http://www.imageupload.co.uk/images/2018/10/15/Londonpods.png" border="0"></a>

 

[RoryA]

Welcome to the forum.

You could use something like this:

Cells(rows.count, "I").end(xlup).offset(1).formular1c1 = "=IF(AND(RC3=R[-1]C3,RC15=R[-1]C15),R[-1]C,"""")"

 

[LittleJon]

Thanks, ill try this. What does the RC3=R refer to?

 

[RoryA]

RC3 means "this row, third column" (i.e. col C of the row with the formula)
R[-1]C3 means "the row above, third column". (i.e. col C of the row above the formula row)