I have a list of product descriptions in Column B (starting at B3) and each of these product descriptions contains a text string. I've created a table of the text stings I'm searching for in Column F. I would like to create a formula that will search the list in Column B for the text string in the table I've created in Column F and then if found, populate Column C with that text string found in Column F.
I've attached a sample of the workbook I'm working in. I've come up with the array formula {=IF(ISNUMBER(SEARCH($F$3:$F$11, B3)), $F$3:$F$11, "")} but it doesn't work for every row in column B. It only works if the test string I'm searching for is in the first cell of the table in column F.
Can anyone help me out with making this formula work?
Bookmarks