Search multiple URL's and return value dependant on Keyword

[pgrad]

Hi All,

I am hoping someone can help.

I need to search through 4000 URLS in column 'C' and if they contain a keyword / text string from a list in column 'A' then I would like to retun a value from column 'B'.

Any suggestions would be great.

Thanks
Paul

 

[GlennUK]

Can you give an example of what you want?

 

[pgrad]

Hi Glenn,

Sorry for the late reply.

I managed to come up with a horrible work around, I will know in the next week or so if this is going to become a regular report or is a one off.

In which case I will no doubt be bothering the forum for some advice and a more elegant solution.

Thanks for the reply

Paul