Need Help - How to compare two sets of data?

I attached an example file which clearly shows what I am trying to do. Here is the explanation:

I have two sets of data. The first set has an item number and purchase price that I want to compare to a second set which is item number and sale price. The item number remains the same, I just need a formula that searches second data set to find the matching item number and compares the purchase price against the sale price to determine the profit or loss on each item number.

Your help is appreciated!

Thanks!

I6 = Item #
;; either copy/paste it in somewhere, or just drag one set or the other, or whatever.

J6 = purchase price - sale price
;; lookup (using INDEX(MATCH) construction) of the purchase price and sales prices from their respective tables indexed of the Item #, and then the net revinue from that.

Please Login or Register  to view this content.

Hi Chemist,

Your formula works great. One last question - it there a way to add a column to show the actual dollar value for profit/loss in addition to the percentage?