Posted to microsoft.public.excel.misc

TWP

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Indexing	Anto111	Excel Discussion (Misc queries)	1	July 26th 08 08:01 PM
Tab indexing	ibgolfn	Excel Discussion (Misc queries)	2	January 16th 08 12:04 AM
Indexing	M&M[_2_]	Excel Discussion (Misc queries)	1	July 13th 07 07:10 PM
Indexing of Name	Charlie	Excel Worksheet Functions	1	April 5th 06 01:33 PM
Indexing a row	ecohen1	Excel Worksheet Functions	6	July 20th 05 06:11 PM

All times are GMT +1. The time now is 12:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us