Lookup match difference

Closed
Report
Posts
1
Registration date
Tuesday July 14, 2015
Status
Member
Last seen
July 14, 2015
-
Hello,
I have 2 sets of data:
a b c d
MEL MEL2 BOB BOB2
yx124 $100 xyz $200
xyz $200 abd1 $150
abd1 $175 29aa $60

I want to find all the matchs from a to b and display the difference from b to d, also to include a list of matched items

the results would be:
yxz124 $100 as it is in colm a but not in colm c(notewherefound MEL)
xyz $match as is is found in both a & c and there is not differenc
abd1 $25 as it is found in both colm a + b, but has a difference
29aa $60 as it is found in c but not a (Note where found BOB)

Thanks in advance