You wrote

I do not think it is fully working please see attached

But what is not working? Please be specific. I don't know what you mean by 12345, 58244 and 48125. None of these seems to be neither Product number nor Reference number.

I guess it is all completely obvious to you, but not to me.

It must be possible for you manually enter more (at least five) examples of expected results and specifically indicate which cells return wrong result.

Also I don't know what you mean by your last sentence.
(English is not my mother tongue which partly may explain my difficulties in understanding).