Hi
Don't know how to explain, but formulae is as follows:
If a number ref matches in the first sheet within cell N8 then from
sheet 1 whatever is in cell I8 should pull through to I8 in sheet2.
This is the formulae in sheet 2 cell I8
=IF([cpleger.xls]Sheet1!N8=2,[cpleger.xls]Sheet1!$I8)
I8 has to show dates, so the cell format is dd/mm
However when the date in sheet 1 is blanked out, in sheet two it shows
as 00/01
Is there a way to make it show nothing in sheet 2 if it shows nothing
in sheet 1?
------------------------------------------:)
--
Boethius1
------------------------------------------------------------------------
Boethius1's Profile:
http://www.excelforum.com/member.php...o&userid=30497
View this thread:
http://www.excelforum.com/showthread...hreadid=517023