Shawn Dunn
New Member
- Joined
- May 7, 2015
- Messages
- 3
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?
=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?