Thread: Match Function
View Single Post
  #1   Report Post  
Andri
 
Posts: n/a
Default Match Function

Dear All,
I would like to know the back order status of item purchased.
Sheet1 : about the purchase file contains fields such as PO#, PN, Qty
Bought, Price,etc
Sheet2 : about the items received contains fields such as PO#, PN, Qty
Received,etc

Please advice how to compare Qty Bought - Qty Received, based on Match on
PO# AND PN in Sheet1 AND Sheet2.

Thank you.
Andri