IF Statement???

F

Fish

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
 
T

T. Valko

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
 
F

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

T. Valko

You're welcome. Thanks for the feedback!

Biff

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

Fish
Click to expand...
 
Top