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