I have a column as named particulars below and my requirements are in columns ahead...plz someone can give me a solution.. Would be grateful…thanks in advance.
<tbody>
</tbody>
Particulars | Look up fields from the column 1 | End result required for individual look up field | End result required for individual look up field | | | |
SWL 3.70 MT. @ 255 PMT. OCC 20.08 MT. @ 180 PMT. AS D/O NO.3499 W/SLIP NO. 205888/205890 DTD 01/01/13 | SWL & OCC | 3.7 | 20.08 | | | |
OCC 18.04 MT. @ $ 180 PMT. SWL 5.29 MT. @ $ 255 PMT. AS D/O NO.3500 W/SLIP NO.205957/205960 DTD 02/01/13 | OCC & SWL | 18.04 | 5.29 | | | |
OINP 27.65 MT. @ 678.95 PMT. ( JAN-PUR) W/SLIP NO.530880 & UNIBRASS INV# 12218/2012 | OINP | 27.65 | | | | |
OCC 75.33 MT. @ 543.34 PMT. OINP 6.779 MT. @ 580.32 PMT. POC 2.897 MT. @ 500.51 PMT. SWL 3.694 MT. @ 700.05 PMT. MIX 0.33 MT. @ 500 PMT. MIX/WST 1.06 MT. @ 321.69 PMT. OFF/WST 0.80 MT@ 500 PMT.-001 | OCC, OINP, POC, SWL, MIX, MIX/WST, OFF/WST | 75.33 | 6.779 | 2.897 | 3.694 | etc… |
OCC 20.530 MT. @ 180 PMT. AS D/O NO. 5301 AS W/SLIP NO. 206000 DTD 03/01/13 | OCC | 20.53 | | | | |