Thread: Indexing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TWP TWP is offline
external usenet poster
 
Posts: 7
Default Indexing

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