Search a text for a array of values

Hello,

I have a array of values, i need to search a text if any of the array of values exist in it.

I used below, it works fine but if there is a text like "1. Ship(R45100A)" and both R45100 & R45100A exist in array, it shows result as R45100. but expectation is to get R45100A

=INDEX(Objects!A:A,AGGREGATE(15,6,ROW(Objects!A$2:A$50)/(ISNUMBER(SEARCH(Objects!A$2:A$50,A2))),1))

OR is there a way to get the count of values in array found in text?

PFA data, please let me know if any thoughts

Thanks
Amith