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.

[TABLE="width: 411"]
<tbody>[TR]
[TD="width: 459, bgcolor: transparent"]

Column A​

[/TD]
[TD="width: 89, bgcolor: transparent"]

Column B​

[/TD]
[/TR]
[TR]
[TD="width: 459, bgcolor: transparent"]

String​

[/TD]
[TD="width: 89, bgcolor: transparent"]

Part #​

[/TD]
[/TR]
[TR]
[TD="width: 459, bgcolor: transparent"]

1A18A010 159822 930-SC 0 0 0 40 170 01/17/2019 300.0000​

[/TD]
[TD="width: 89, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 459, bgcolor: transparent"]

1A18B006 160018 500 109X 01/17/2019 500.0000​

[/TD]
[TD="width: 89, bgcolor: transparent"]

​

[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 60"]
<tbody>[TR]
[TD="width: 80, bgcolor: transparent"] Part # List
[/TD]
[/TR]
[TR]
[TD="width: 80, bgcolor: transparent"] 107S
[/TD]
[/TR]
[TR]
[TD="width: 80, bgcolor: transparent"] 109X
[/TD]
[/TR]
[TR]
[TD="width: 80, bgcolor: transparent"] 930-sc
[/TD]
[/TR]
[TR]
[TD="width: 80, bgcolor: transparent"] 291C
[/TD]
[/TR]
</tbody>[/TABLE]


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.