Copying formula

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

Michael Koerner

I have the following formula in cell A1 =IF(B1="","",ItemList!B2) When
dragging/copying the formula to down to A2, A3 etc How do I keep the ItemList
cell reference = to B2?
 
By absulute reference:
A1 =IF(B1="","",ItemList!$B$2)
regards,
Stefi

„Michael Koerner†ezt írta:
 
Thanks, I was missing the 2nd $

--

Regards
Michael Koerner


By absulute reference:
A1 =IF(B1="","",ItemList!$B$2)
regards,
Stefi

"Michael Koerner" ezt írta:
 
Very very easy: lock the cell reference in the formula.
Highlight "B2" in your formula and press F4. It will become:
=IF(B1="","",ItemList!$B$2)

The $ signs indicate that both the row and column references ar
locked.
(you could also lock rows only: B$2 or columns only: $B2 by pressin
F4 several times or by directly adding the $ signs in the formula.
 
Much appreciated, thank you very much.

--

Regards
Michael Koerner



Very very easy: lock the cell reference in the formula.
Highlight "B2" in your formula and press F4. It will become:
=IF(B1="","",ItemList!$B$2)

The $ signs indicate that both the row and column references are
locked.
(you could also lock rows only: B$2 or columns only: $B2 by pressing
F4 several times or by directly adding the $ signs in the formula.)
 
Back
Top