IF ISNUMBER SEARCH combination

[samcam]

I'm using the current formula:
=IF(ISNUMBER(SEARCH("Nature",A2)), "Y", "")
to show whether a word (shown in cell B1) features in a set of meta tags (shown in cell A2).

	A	B	C	D	E
1		Nature	Ocean	Sun	People
2	Nature;Ocean;Outdoors;Water;Sky	Y	Y
3	People;Sea;Waves;Sun			Y	Y

<tbody>
</tbody>

I would like to use a full formula rather than having to type in the word so it's easier to copy the formula through. Currently it's not letting me do it and I have to type the word in.
I understand I possibly have to remove the semi-colons for it to work so happy to split into separate cells, but if anyone has any help that would be great!

 

[Phuoc]

Try this:

=IF(ISNUMBER(SEARCH(B$1,$A2)), "Y", "")

 

[samcam]

No this hasn't worked.

 

[Phuoc]

Maybe?

=IF(ISNUMBER(SEARCH(";"&B$1&";",";"&$A2&";")), "Y", "")

 

[Marcelo Branco]

No this hasn't worked.

Phuoc's formula in B2 copied across and down worked perfectly for me

M.