Copying formula

[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?

--

Regards
Michael Koerner

[lux770]

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

[Stefi]

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

[Michael Koerner]

Thanks, I was missing the 2nd $

--

Regards
Michael Koerner


"Stefi" <[email protected]> wrote in message
news:[email protected]...
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
>
>
>
>

[Michael Koerner]

Much appreciated, thank you very much.

--

Regards
Michael Koerner


"lux770" <[email protected]> wrote in message
news:[email protected]...

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