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

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

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

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

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

"Gord Dibben" wrote:

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

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

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

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

How do you know "it" should be blank?



Gord




On Wed, 22 Apr 2009 13:39:02 -0700, TWP
wrote:

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

"Gord Dibben" wrote:

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

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

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

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

"Gord Dibben" wrote:

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

How do you know "it" should be blank?



Gord




On Wed, 22 Apr 2009 13:39:02 -0700, TWP
wrote:

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

"Gord Dibben" wrote:

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

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

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

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

I'm out of ideas for now.


Gord

On Wed, 22 Apr 2009 14:27:01 -0700, TWP
wrote:

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

"Gord Dibben" wrote:

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

How do you know "it" should be blank?



Gord




On Wed, 22 Apr 2009 13:39:02 -0700, TWP
wrote:

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

"Gord Dibben" wrote:

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

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

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