Solution for looping of two data set

[a_driga]

Dear all,

I have two data sets as shown in sheet 1 (please refer to my file). In my original file, those tables placed in different sheet. What I want to do is to create a table as shown in the right most table.

In order to do so, I have to do a loop which I cannot solve.

For example, in order to find item A:


My solution so far
Area highlighted with light-green started as empty
A row above the green-highlighted area have been filled (header) using syntax.

I check every row in table 1 to find a match between those in column B with column J (in table 2) AND column C with column H (in table 2). The search row begin from row number 3
If a match is found, then cell M1 will be filled with value from E1 and N2 from D1
Since item A were delivered twice (partial delivery), a next search needs to be done to fill value in O1 & P1
However, the next search will be started from row 4 instead of row 3.

In in table 2, from row 8 to end must be checked

How can I build the syntax??

Any help would be greatly appreciated.

[a_driga]

I have found the solution...

Thanks for anyone who has read my thread...

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.