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).

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Nature[/TD]
[TD]Ocean[/TD]
[TD]Sun[/TD]
[TD]People[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Nature;Ocean;Outdoors;Water;Sky[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]People;Sea;Waves;Sun[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]


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.