Search within text and IF solution needed

Hello,

First post here.

I help and I'm hoping someone out there has an answer. Probably simple for a lot of you.

I need to search within the text of a cell and output a certain value in the cell next to it.

I'm currently using this: =IF(SEARCH("*1629*",A1,1),"1629","") but I need to serach for multiple values.

I've attached an example. Row 1 has the result I need using the formula. Row 2 and 3 show the value I need and how it should look, but I just put the values there manually.

A B
cat dog xyz def ghi lakers suck "1629 1629
apple tree house fly Lebron sucks too "1633" 1633
it is hot in arizona "1655" really hot 1655


thanks

Hi, try using following UDF

Please Login or Register  to view this content.