Indexing

[TWP]

My formula reads as follows
=INDEX('Agency Relief'!$B$2:$AG$103, MATCH($B34,'Agency
Relief'!$B$2:$B$103), MATCH($C2,'Agency Relief'!$B$2:$AG$2))
In the cell it is giving me a date when I know it should be blank. When
there is an answer it does put it there but I don't want these dates in the
cell when it is supposed to be blank...Please help

 

[Gord Dibben]

Excel treats cells with a formula returning nothing as zero value.

Is the formula cell formatted as Date and you get 1/0/00?

What do you see when you format to General or Number?


Gord Dibben MS Excel MVP

 

[TWP]

It is giving me a number value of a date. It is already formatted as general.

 

[Gord Dibben]

Then your formula must be returning a value, not nothing.

How do you know "it" should be blank?



Gord

 

[TWP]

I have not put any information in the cell that it is matching, so it should
be blank.

 

[Gord Dibben]

And yet you say the formula is returning the number value of a data?

I'm out of ideas for now.


Gord