Hello,

I asked this question a couple of days ago but I don't think that I stated
it well enough as the formula that was given to me was not quite what I
needed.
I'll try again.

In my spread sheet in cell D3 is a date, lets say 10/22/2009

In Column A from Cell A18 thru A32 are other dates. I need a formula that
will check A18 thru A32 against D3 and if the date matchs I need to populate
that respective cell (A whatever) with effective date or if a match is not
found I need to populate the cell with not effective.
So if A19 matches I need effective date in that cell, if A25 doesn't match I
need not effective in that cell.
Thanks in advance for any help you can give me.