Indexing
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
|