Checking a cell to see if it has three possible words?

[species8514]

I have a cell which may possibly contain the names Mick or Paul or Bryn, and i want to create a formula which checks and returns a true or false value, if it finds a match.

I have been able to create one that checks for one name, but as soon as i try and nest a second, it messes up.

Any suggestions?

Thx guys.

 

[onlyadrafter]

Hello,

look here

http://www.mrexcel.com/board2/viewtopic.php?t=236173

 

[lenze]

Maybe:

IF(OR(A1="Mick",A1="Paul",A1="Bryn"),TRUE,FALSE)

lenze

 

[species8514]

Thanks!

That works well, although i was wondering if there is a way i can search the cell for the names? The above works if there is just the name on it's own, but if it's within a sentence, for example, Bryn made tea, it wont obviously find it. I guess i need a SEARCH function?

Thanks again guys

 

[SamBo1234]

You could try this, Not an expert but it seems to do what you requested.

=IF(OR(SEARCH("Name1",A1),SEARCH("Name2",A1),SEARCH("Name3",A1)),"True","False")

Replace the Name1,Name2,Name3 with your selected Criteria

If it doesnt meet all criteria it will return a #VALUE in the Cell so u can distinguise the ones that do and dont meet the criteria, im sure u can get better than the above but im far from expert at this!!!

Hope it helps anyways.

 

[lenze]

Have a look at SEARCH and FIND functions. FIND is case sensitive

lenze