Determine if a cell with text contains a keyword from a list

[BJR25]

Hi

I have coulum A which contains text seperated with / and , I want to run a VLook Up against it to see if a list of words in another coulum exist in it if they do put the word that was found in coolum B in the below example I would be looking to find the word Learning

Can anyone help.

Directors-of-Learning/
Parents/Directors-of-Learning/[/url]

[6StringJazzer]

Welcome to the Forum BJR25!

I modified your title to reflect your actual question. Your title does not really tell us about your question, and also assumes that VLOOKUP is the answer when VLOOKUP can't be used for this.

It would be very helpful to provide a small sample file. I think I understand your description, but your example does not show much and does not show how you want the result to look. With a sample file we can test our solution before giving it to you. See yellow banner at the top of the page.

[Croweater]

If your keywords are in D1 to D5 try this in B1 and drag down

Note: This is an array formula so it is entered by holding down Ctrl and Shift and pressing enter.

=IFERROR(INDEX($D$1:$D$5,SMALL(IF(COUNTIF($A1,"*"&$D$1:$D$5&"*"),MATCH(ROW($D$1:$D$5),ROW($D$1:$D$5)),""),COLUMNS($A$1:A1))),"")

[Glenn Kennedy]

An ordinary formula (just enter):

=IFERROR(LOOKUP(1000,SEARCH($F$1:$F$3,A2),$F$1:$F$3),"")

where F1-F3 is your list of keywords and A3 is the text you are searching for those keywords.

Next me, please read the yellow banner (top of page) and attach a sample Excel sheet, complete with a set of representative examples.