If cell b1,b2 or b3 is contained in cell a1, then enter the word that is contained in cell a1

[jeremypyle]

If I had 2 lists. List 1 was in column A and list 2 was column B :

A1) bigtomato
A2) fatamerican
A3) happysailer

B1) round
B2) hat
B3) big

And I want to have a code that says if A1 contains (B1,B2 or B3) then enter that contained word. In this case A1 contains the word "big" from B3

How would I code this:

I have tried created the following code in C1
=IF(OR((ISNUMBER(SEARCH($B1,$A1))),(ISNUMBER(SEARCH($B2,$A1))),(ISNUMBER(SEARCH($B3,$A1)))),$B1,"")

This code only works if the word "big" was in cell one

The code somehow needs to say if A1 contains B1,B2 or B3 then enter b1,b2 or b3 (depending on which word was contained)

If you can figure this out, you are a GENIUS!!!

 

[jeremypyle]

I was entering ctrl shift enter

still not working

im not concerned about the word "far"

It wouldn't be possible to email the excel sheet would it. That would be so helpful

jeremypyle@e-mail.ph