Need an Excel Formula to find columns with certain key words?

[ltn123]

Lets say Column A is a list of URLs. Column B is a list of keywords.

I need a formula where if any of the keywords in Column B is found within the url structure in A it spits out the URL is column C.

Thanks

 

[MarcelBeug]

With all due respect, I think there is some misunderstanding about what you are looking for.
Scott's formula verifies for each keyword if it can be found anywhere in column A.
My formula verifies for each URL if it contains any of the keywords in column B.

So if I'm right, with your settings, type in C2:

=IF(OR(NOT(ISERROR(SEARCH(B:B|A2))))|A2|"")

Finish typing not with ENTER but with CTRL-SHIFT-ENTER which makes it an array formula, surrounded by curley brackets (don't type these yourself):

{=IF(OR(NOT(ISERROR(SEARCH(B:B|A2))))|A2|"")}

Copy down and it really should work. i.e. if I'm right with respect to what you're looking for.

 

[Scott Huish]

Wouldn't this accomplish the same thing?

=IF(ISNUMBER(SEARCH(B:B,A3)),A3,"")

Confirm with CTRL-SHIFT-ENTER