Here's what I need to do: One column (D2) in my spreadsheet has the coverage
dates of periodicals . I need to come up with the formula that would insert
"Current" into a new column if the coverage date cell has any of the
following words: present, days, or months. If the coverage date does not
have any of those three words, I want a blank cell. Any help would be muchly
appreciated!

Assuming that you are saying that the coverage date cell has other things in
it beside the target words then try:

=IF(ISNUMBER(LOOKUP(10,1/SEARCH({"present","days","months"},D2))),"Current","")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"MaryFran" <(E-Mail Removed)> wrote in message
news:63019E2F-0B36-44F5-A66C-(E-Mail Removed)...
> Here's what I need to do: One column (D2) in my spreadsheet has the
> coverage
> dates of periodicals . I need to come up with the formula that would
> insert
> "Current" into a new column if the coverage date cell has any of the
> following words: present, days, or months. If the coverage date does not
> have any of those three words, I want a blank cell. Any help would be
> muchly
> appreciated!
>
>
>

hi
try this....
=IF(OR(D2="present",D2="days",D2="months"),"current","")
copy down?

Regards
FSt1

"MaryFran" wrote:

> Here's what I need to do: One column (D2) in my spreadsheet has the coverage
> dates of periodicals . I need to come up with the formula that would insert
> "Current" into a new column if the coverage date cell has any of the
> following words: present, days, or months. If the coverage date does not
> have any of those three words, I want a blank cell. Any help would be muchly
> appreciated!
>
>

Sandy,

This worked perfectly! Thanks so much for your help!

"Sandy Mann" wrote:

> Assuming that you are saying that the coverage date cell has other things in
> it beside the target words then try:
>
> =IF(ISNUMBER(LOOKUP(10,1/SEARCH({"present","days","months"},D2))),"Current","")
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "MaryFran" <(E-Mail Removed)> wrote in message
> news:63019E2F-0B36-44F5-A66C-(E-Mail Removed)...
> > Here's what I need to do: One column (D2) in my spreadsheet has the
> > coverage
> > dates of periodicals . I need to come up with the formula that would
> > insert
> > "Current" into a new column if the coverage date cell has any of the
> > following words: present, days, or months. If the coverage date does not
> > have any of those three words, I want a blank cell. Any help would be
> > muchly
> > appreciated!
> >
> >
> >
>
>
>

You are very welcome. Thanks for taking the time to let us know that it
worked for you.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"MaryFran" <(E-Mail Removed)> wrote in message
news:66F80CE4-0613-48A7-ABE7-(E-Mail Removed)...
> Sandy,
>
> This worked perfectly! Thanks so much for your help!
>
> "Sandy Mann" wrote:
>
>> Assuming that you are saying that the coverage date cell has other things
>> in
>> it beside the target words then try:
>>
>> =IF(ISNUMBER(LOOKUP(10,1/SEARCH({"present","days","months"},D2))),"Current","")
>>
>> --
>> HTH
>>
>> Sandy
>> In Perth, the ancient capital of Scotland
>> and the crowning place of kings
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "MaryFran" <(E-Mail Removed)> wrote in message
>> news:63019E2F-0B36-44F5-A66C-(E-Mail Removed)...
>> > Here's what I need to do: One column (D2) in my spreadsheet has the
>> > coverage
>> > dates of periodicals . I need to come up with the formula that would
>> > insert
>> > "Current" into a new column if the coverage date cell has any of the
>> > following words: present, days, or months. If the coverage date does
>> > not
>> > have any of those three words, I want a blank cell. Any help would be
>> > muchly
>> > appreciated!
>> >
>> >
>> >
>>
>>
>>
>