Hi,

I have a spreadsheet which is causing me a headache!

I have two sheets, one of which contains film names and the other contains our tag structure for our website (which is a list of tags, their keywords and the primary parent channel they live under).

What I am trying to do is search the film titles and if any of the words match either the tag name or keywords then return the relevant channel.

Example:

Sheet 1 - Films
How To Apply Bridal Makeup
How To Fight A Donkey
How To Write Excel Formulae

Sheet 2 - Tags
Channel / Tag / Keywords
Tech - Microsoft - windows vista xp word excel
Tech - Computers - internet pc
Tech - MP3 Players - iPod Zune

So, for film 3 on Sheet 1 it would recognise the word Excel in the keyword list and return the channel Tech.

Appreciate any help, if you need more info just let me know :-)