software

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: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=517023
This should work.

=IF([cpleger.xls]Sheet1!N8=2,[cpleger.xls]Sheet1!I8,quot;quot;)

This will return a blank if [cpleger.xls]Sheet1!N8 does not equal 2.HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517023
Actually, I think this is what you were looking for.

=IF(AND([cpleger.xls]Sheet1!N8=2,Sheet1!I8lt;gt;quot;quot;),[cpleger.xls]Sheet1!I8,quot;quot;)

This is where if Sheet1!N8 = 2 and Sheet1!I8 is not blank it will
return the date in Sheet1!I8. If Sheet1!N8 =2 and Sheet1!I8 is blank,
it will return blank.

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517023
Hi,
it works if i press space bar to delete information but not if i press
delete key. still shows as 00/01. As i need to highlight several to
hundreds of cells space bar is not an option. any other ideas? thanks
for your quick replies.

Could it be because i have formatted the column to show as a date?

--------------------
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=517023I think SteveG had a typo in his suggested formula:

=IF(AND([cpleger.xls]Sheet1!N8=2,Sheet1!I8lt;gt;quot;quot;),[cpleger.xls]Sheet1!I8,quot;quot;)

should be:

=IF(AND([cpleger.xls]Sheet1!N8=2,[cpleger.xls]Sheet1!I8lt;gt;quot;quot;),
[cpleger.xls]Sheet1!I8,quot;quot;)

(all one cell)

He was pointing at sheet1!i8 of the current workbook--not in cpleger.xls.

If that didn't help, you should post the formula you're using.

Boethius1 wrote:
gt;
gt; Hi,
gt; it works if i press space bar to delete information but not if i press
gt; delete key. still shows as 00/01. As i need to highlight several to
gt; hundreds of cells space bar is not an option. any other ideas? thanks
gt; for your quick replies.
gt;
gt; Could it be because i have formatted the column to show as a date?
gt;
gt; ------------------
gt;
gt; --
gt; Boethius1
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=517023

--

Dave Peterson


Thank you both very much, it does now work exactly as i wanted!!
--------------------------------
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=517023