Improve fuzzy match filter

[chilly_bang]

I'm working with two different formulas, which do the same thing: they match a (partly) value from one "filter" column in another column, and, in case of match, they write "delete" into the same row of the column A, where the match happens, otherwise they write "keep". Here are the formulas:

[COLOR=#242729][FONT=Consolas]=IF(SUMPRODUCT(COUNTIF(A2,"*"&B$2:$B$22&"*"))>0,"Delete","Keep")

[/FONT][/COLOR][COLOR=#242729][FONT=Consolas]=IF(SUMPRODUCT(--ISNUMBER(SEARCH($B$2:$B$22,A2))),"Delete","Keep")

[/FONT][/COLOR]

On screenshot is an example of working formula:

I want to improve the formulas so, that i get instead of "delete" the matched value from column B. How could i achieve this?<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;"></code>

 

[Marcelo Branco]

Try

=IFERROR(LOOKUP(9.99E+307,SEARCH(B$2:B$7,A2),B$2:B$7),"Keep")

M.

 

[chilly_bang]

You are great! Works like a charm!

 

[Marcelo Branco]

Glad to help. Thanks for the feedback.

M.