Sort and Merge

[Chan_Tze_Leong]

I have 2 excel tabs : Purchase Order and Goods Received.
I am trying to match the Purchase Order from both tabs and then, proceed to match the Material from both tabs so that I can know, out of the total purchase order, how much has been delivered. Any suggestions?

[#2]

Please edit your post & share the expected output (which column from which sheet) since both sheets has so may columns,, will help me & others to fox the issue !!

[#3]

@Chan_Tze_Leong 

That's confusing! 'Rear cross-members' were received but never ordered!