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


Replace @mailinator.com with @tiscali.co.uk


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


Replace @mailinator.com with @tiscali.co.uk


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


Replace @mailinator.com with @tiscali.co.uk


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


Replace @mailinator.com with @tiscali.co.uk


"MaryFran" wrote in message
...
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"),"curren t","")
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!