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.

I think you need to use a separate column. What you've described is
*replacing* the date in column A with either "effective date" or "not
effective".

Enter this formula in B18 and copy down to B32:

=IF(A18=D$3,"Effective Date","Not Effective")

--
Biff
Microsoft Excel MVP


"Dianne" wrote in message
...
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.

The way you wrote that, you are overwriting the date/date that was already in
the A column with new information? Is that really what you want? I will
assume that you actually want the new information in B column.

In B18:
=IF(A18=D$3,"Effective Date","Not Effective")

Guessing again, you might want:
=IF(A18<=D$3,"Effective Date","Not Effective")

if you actually are checking for dates that have already earlier than the
date in D3. Copy down the formulas as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dianne" wrote:

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.