few cells info in one cell

[Erenstas]

Hello,

I have such info in a table (provider, purchase order nr, date when it has to arrive , comapany inside code for this part, part numeber(providers) quantity

	MOUSER ELECTRONICS ( ES)	ERGR180829-1276		2018.09.17			0	12R-00548	MMSZ5246B-7-F		10

<tbody>
</tbody>

and info from provider (purchase order nr, part number, comapny inside code, quantity, confirmed delivery date)

<tbody>
</tbody>

ERGR180829-1276/1

MMSZ5246B-7-F

012R-00548

7

20181015

<tbody>
</tbody>

ERGR180829-1276/2

MMSZ5246B-7-F

012R-00548

3

20181025

<tbody>
</tbody>

I have tried lot of formulas, with ifs, match, index and so on, but formula gets too big, and it doesn't solve problem.

I need to get value from suplier table, on what dates we are getting this part ( we want it on one date, thei confirmed on other, most of the time these date doesnt match). I have info PO number, and inside code (I believe, that is the best case to use these two), but there are a problem that Pn doesn;t always match, I know hot it starts, and how much symbols it includes. also there may be partly shipment, like in example 7pcs arrives first, and later 3pcs, but I have info in one line that all quantity arrives at the same time, and I get just first date...

any sugestions, how can I solve this, is it better tu use formulas, or in this case better to try macro?