I'm working on matching a set of search queries to identified keywords I am tracking. Here is an example:
A B C 1 query Keyword 2 policy policy 3 policy and procedure guideline 4 sick pay guidelines agenda 5 calendar brochure 6 medical leave calendar
Column A contains the search query. Column C contains the list of keywords. I'm trying to find a formula for column B that will match any part of cell A3 to any cell in C and then tell me what the value of C is. For example I would like cell B2 to read "Policy", B3 to read "policy", likewise B4 should read "guidelines". I'm very close with an Index Match formula, but I can only get it to match the first word and then it goes to the closest value in column C. I say I would like a formula, but a VB script would be ok too (very novice at visual basic though).
Bookmarks