I am looking for a way to populate a cell with a value if another cell has a
certain word in it. If "A1" has "newark pre-owned" in it I would like to
search for "pre-owned" only and insert my value in "B1."

Thanks in advance for your assistance.

Fish

Here's one way:

Enter this formula in B1:

=IF(COUNTIF(A1,"*pre-owned*"),your_value_here,"")

Replace your_value_here with your value. If your value is a number just
enter that number: 10. If your value is a TEXT string enclose it in quotes:
"Yes".

The "" at the end will leave the cell blank if pre-owned is not found in
cell a1.

Biff

"Fish" wrote in message
...
I am looking for a way to populate a cell with a value if another cell has
a
certain word in it. If "A1" has "newark pre-owned" in it I would like to
search for "pre-owned" only and insert my value in "B1."

Thanks in advance for your assistance.

Fish

Awesome, thank you very much. You have saved me hours of sorting through over
50,000 terms and pasting as needed. Thanks again.

Fish

"T. Valko" wrote:

Here's one way:

Enter this formula in B1:

=IF(COUNTIF(A1,"*pre-owned*"),your_value_here,"")

Replace your_value_here with your value. If your value is a number just
enter that number: 10. If your value is a TEXT string enclose it in quotes:
"Yes".

The "" at the end will leave the cell blank if pre-owned is not found in
cell a1.

Biff

"Fish" wrote in message
...
I am looking for a way to populate a cell with a value if another cell has
a
certain word in it. If "A1" has "newark pre-owned" in it I would like to
search for "pre-owned" only and insert my value in "B1."

Thanks in advance for your assistance.

Fish

You're welcome. Thanks for the feedback!

Biff

"Fish" wrote in message
...
Awesome, thank you very much. You have saved me hours of sorting through
over
50,000 terms and pasting as needed. Thanks again.

Fish

"T. Valko" wrote:

Here's one way:

Enter this formula in B1:

=IF(COUNTIF(A1,"*pre-owned*"),your_value_here,"")

Replace your_value_here with your value. If your value is a number just
enter that number: 10. If your value is a TEXT string enclose it in
quotes:
"Yes".

The "" at the end will leave the cell blank if pre-owned is not found in
cell a1.

Biff

"Fish" wrote in message
...
I am looking for a way to populate a cell with a value if another cell
has
a
certain word in it. If "A1" has "newark pre-owned" in it I would like
to
search for "pre-owned" only and insert my value in "B1."

Thanks in advance for your assistance.

Fish