Searching / Selecting Text Values from Data List

[craigmcmenemy]

Hi guys,

I'm stuck on something which you may be able to help me with - basically, I'm using excel to report on the performance of keywords in my client's google Adwords account. The client is a van hire company with over 60 branches across the UK, and what I would like to do is to group they keywords by which location branch the keyword represents. For example, if the keyword relates to the Manchester branch (e.g. if the keyword was 'van hire in manchester', 'manchester van hire', '+hire +a +van +manchester'), then I'm able to group these all together as 'Manchester'.

As I said, there are 66 different locations so it isn't possible to use a massive IF(ISNUMBER(SEARCH("manchester",A2)),"Manchester",IF(ISNUMBER... type function because there is a limited to the number of nested if statements. What I'd like to do would be to search an array of terms, and if this term appears anywhere within the keyword, the data from a corresponding column will be selected, for example:

Keyword
+van +hire +milton +keynes
Formula searches an array for a matching value within the text, in this case 'keynes'
Branch Name is provided, which is Milton Keynes.

I hope this makes sense, if any further clarification is needed I'll do my best to explain!

Thanks very much in advance!

Craig

[Richard Buttrey]

Hi,

It would be better of you could upload your workbook so that we can see the request in context. Manually add some typical results that you expect to see. Don't forget you can always use the wild card character * in searches e.g. Search("*Manchester*",A1).

[craigmcmenemy]

Hi Richard,

Thanks a lot for the response, I appreciate that.

Example spreadsheet attached,

Thanks,

Craig