Leaving a cell blank until a value is entered

[pajc72]

Hi,

I have a formula (below) in my league table spreadsheet that looks at a fixture list and returns the fixtures for the team that is selected in cell D1

=INDEX(Fixtures!$B:$H,IF(ISERROR(MATCH($D$1&$A4,Fixtures!$J:$J,0)),MATCH($D$1&$A4,Fixtures!$K:$K,0),MATCH($D$1&$A4,Fixtures!$J:$J,0)),3)

The problem is that if the score hasnt been entered yet the formula brings back a '0'.

I would like to know what needs to be added to the formula to leave the cell blank until a score is entered on the fixture sheet

many thanks
Pete

[Undutchable]

It might be possible in another way but:

You could use conditional formatting, if the value in the cell equals 0, font color to white.

Not fancy, but effective

[pajc72]

Ah, but if the score is 3-0 then the 0 wouldnt show

The fixtures are for an NHL season so your idea works nicely for the OT/SO column

[NBVC]

If you add a helper column that concatenates column J and K, is say column I, with a formula like: =J2&K2 , then you can apply formula like:

=IF(INDEX(Fixtures!$B:$I,MATCH($D$1&$A4,Fixtures!$I:$I,0),3)="","",INDEX(Fixtures!$B:$I,MATCH($D$1&$A4,Fixtures!$I:$I,0),3))

which assumes that the combination of D1&A4 will appear in column I.