Help with pasting a formula with a slight variance in other columns on same row.

[Shawn Dunn]

I have the following formula:
=IFERROR(VLOOKUP($C$4,'Schedule & Results'!$C$111:$D$116, 2, FALSE),VLOOKUP($C$4,'Schedule & Results'!$F$111:$G$116, 2, FALSE)).

I want to copy it to other cells in the same row, but with a slight modification. It would be:
=IFERROR(VLOOKUP($F$4,'Schedule & Results'!$C$111:$D$116, 2, FALSE),VLOOKUP($F$4,'Schedule & Results'!$F$111:$G$116, 2, FALSE))

I have additional columns to make this slight change (column I, L, O, U, X, AA, AD, AG, & AJ).
Other than changing the folumla one by one is there an easier way to do so?

 

[RasGhul]

in a spare row in paste your formula but with locked row lookup reference

=IFERROR(VLOOKUP(C$4,'Schedule & Results'!$C$111:$D$116, 2, FALSE),VLOOKUP(C$4,'Schedule & Results'!$F$111:$G$116, 2, FALSE)).

Highlight your formula row range, then with your cursor at the end of your formula in the formula bar press CTRL+ENTER.

Delete the formula from the cells in the columns you don't need, then copy & paste CTRL+V your spare row including your formula into your new formula range

 

[Shawn Dunn]

in a spare row in paste your formula but with locked row lookup reference

=IFERROR(VLOOKUP(C$4,'Schedule & Results'!$C$111:$D$116, 2, FALSE),VLOOKUP(C$4,'Schedule & Results'!$F$111:$G$116, 2, FALSE)).

Highlight your formula row range, then with your cursor at the end of your formula in the formula bar press CTRL+ENTER.

Delete the formula from the cells in the columns you don't need, then copy & paste CTRL+V your spare row including your formula into your new formula range

Thank you. I will try this out.

 

[Shawn Dunn]

Thank you. I will try this out.

Works like a charm! Thanks again!