I have a column of part numbers. Each cell in the column has either one or multiple part numbers separated by a comma and space. (Sheet2)

On Sheet1 I have a cell (A1 - A6) to put in the part number I am looking for. In Column B I have a Vlookup formula to find the price of the part number.

The Vlookup formula does not work because of the multiple part numbers in the same cell

How do I create a formula that can pull the correct price for the correct part number even though that part number is combined together with other part numbers in the same cell?

Here is an example:

https://www.dropbox.com/s/hmc4gqei8aancl8/Search.xlsx?dl=0

Notice in Sheet1 Cell A1 and A3 are pulling the same price when they shouldn't.

Also, A5 and A6 are blank but still pulling the same price.

Thanks

Matt