Can I use Isnumber(search()) to extract from a string, from lookup table?

[DerekWooley]

Hello, I am trying to extract part numbers from a columnfull of strings. The part numbers are in different places in each row. I have alist of part numbers so I can wondering if I can use Isnumber(search(Lookup or indexmatch function)) to extract the part #sfor each row. I can’t put the part number next to the string and reference itbecause the part numbers in the strings vary day to day.

I want the Isnumber(Search()) formula to search and returnthe value if it exists in the part # list.

Below is an example of the strings and Part # list.

Column A​	Column B​
String​	Part #​
1A18A010 159822 930-SC 0 0 0 40 170 01/17/2019 300.0000​	​
1A18B006 160018 500 109X 01/17/2019 500.0000​	​

<tbody> </tbody>

Part # List

107S

109X

930-sc

291C

<tbody> </tbody>

Thank you for any help.

 

[steve the fish]

Something like this should work:

=INDEX($A$7:$A$10,MATCH(1,INDEX(--(ISNUMBER(SEARCH($A$7:$A$10,A2))),0),0))

 

[DerekWooley]

Thank you so much! Works perfectly.