Here you go:
=IF(INDIRECT("A"&B1)=0,"",INDIRECT("A"&B1))
Andy.
"bvandijk" wrote in
message ...
It works great but I have another problem now: when the target cell is
empty, the formuleau returns '0' instead of an empty cell.
Any hints on that?
Thanks!
Bas
--
bvandijk
------------------------------------------------------------------------
bvandijk's Profile:
http://www.excelforum.com/member.php...o&userid=32300
View this thread: http://www.excelforum.com/showthread...hreadid=520570