Hi,
I am trying to find a formula that compares the data from one worksheet
to another. If the data matches I want data from another column on the second
page.

Example

WorkSheet -1 WorkSheet -2 Required
Document Item Inv No Document Item Inv No.
81200692 10 83000001 81200011 110
81200905 20 83000002 81200015 400
81200011 110 83000003 81200015 190
81200015 400 83000004 81200159 40
81200691 160 83000005 81200254 30
81200340 10 83000006 81200254 20
81200159 40 83000007 81200340 10
81200254 30 83000008 81200377 40
81200254 20 83000009 81200377 10
81200015 190 83000010 81200691 160
81203085 60 83000011 81200692 10
81203981 10 83000012 81200905 20
81200377 40 83000013 81203085 60
81200377 10 83000014 81203981 10

Please give example.

Thanks for any help

Best Regards

Mehta R G