Excel find or lookup in a string

[kcoleman26]

I have a cell with a sting of data in it.
C4: SR-305, SR-192, SR-193, SR-194, SR-225, SR-18

I have a table with a list of values that I am looking for within that string
A
1. SR-10
2. SR-11
3. SR-12
4. SR-18
5. SR-19

What I want is to look in the cell string of data and if it finds a match to return that match to my cell

In this case look and Cell C4 and if you see any value in that Cell that matches any of the values in my Table then return the value you found.Wwhich it should have found SR-18

 

[SkipVought]

Hi,

Use the FIND() function.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[kcoleman26]

Close what is happening now is it is returning SR-19 from the SR-192 entry so it doesn't recognize the comma. Is there a way to make it look between the commas?

 

[SkipVought]

How about search for 'SR-19,'?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]