Copying formula
 

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?

--

Regards
Michael Koerner

Copying formula
 

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

€žMichael Koerner€� ezt Ã*rta:

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?

--

Regards
Michael Koerner

Copying formula
 

Thanks, I was missing the 2nd $

--

Regards
Michael Koerner


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

"Michael Koerner" ezt írta:

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?

--

Regards
Michael Koerner

Copying formula
 

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.

--
lux77
-----------------------------------------------------------------------
lux770's Profile: http://www.excelforum.com/member.php...fo&userid=2497
View this thread: http://www.excelforum.com/showthread.php?threadid=39055

Copying formula
 

Much appreciated, thank you very much.

--

Regards
Michael Koerner


"lux770" wrote in message
...

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.)


--
lux770
------------------------------------------------------------------------
lux770's Profile:
http://www.excelforum.com/member.php...o&userid=24970
View this thread: http://www.excelforum.com/showthread...hreadid=390552