• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1936
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# HOW TO TEST A CELL TO SEE IF IT CONTAINS EITHER ONE OF TWO

### Customer Question

HOW TO TEST A CELL TO SEE IF IT CONTAINS EITHER ONE OF TWO TEXT VALUES
Submitted: 5 months ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 5 months ago.

are you trying to look at the entire value of a cell for a specific value, or to see if the cell containst the value among other values

for example

cell value = a cat is fat

so do you want to see if the cell contains the word cat for example

or do you want to see if the entire cell value is = to a certain value for example the entire sentance a cat is fat

Customer: replied 5 months ago.
I want to see if anywhere in the cell is the value "cat" or the value "fat"
Expert:  The-PC-Guy replied 5 months ago.

ok, yep that can be done.

what values do you sepcifically want to search for?

Expert:  The-PC-Guy replied 5 months ago.

and which cell do you want to search so I give you correct formula

Customer: replied 5 months ago.
34;wisconsin" or "racine" in a cell range (b2 thru b999)
Customer: replied 5 months ago.
I can just copy the formula down the B column...
Expert:  The-PC-Guy replied 5 months ago.

yes you can do that

=IFERROR(IFERROR(IF(FIND("wisconsin",B2)>0,"yes","no"),IF(FIND("racine",B2)>0,"yes","no")),"no")

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE STARS AT THE TOP OF YOUR SCREEN

Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.

Expert:  The-PC-Guy replied 5 months ago.

i assume that is what you needed.

please don't forget to rate so I am paid for my time

Expert:  The-PC-Guy replied 5 months ago.

Sue are you there?