VLOOKUP works for me when finding exact data in a cell that only has one part number. I want to find a part number in a cell that has multiple part numbers and find corresponding data in columns to the right.

Is there a formula to return that result?

Say that I have the following data:

Cell: A1
RF3-235S,K-42216,MB-25059,MB-25137,MA-SPN5185,AL-UHS206,AL-UHS106,SD-MICRO4,ES-002G

Cell: A2
RF3-225,RF3-125,JB-100-55100000,PL-MX256-M1,PL-MX250

Cell: A3
MB-25135,SSA-AEP010SLEB,RF3-112S,PL-MX510-M1

Is there a vlookup, search, if, or find formula that can look for a model in column A, and return the result from column 2?

For example, is there a formula to find part: PL-MX256-M1 in column A, and return the related data in column B? In this example, the part is in column A2, and I would like to return a vlookup from row 2 (cell b2).

This is my first post. Hopefully, my question was clear. Thanks in advance!