Lookup match difference

Closed
Naser2015 Posts 1 Registration date Tuesday July 14, 2015 Status Member Last seen July 14, 2015 - Jul 14, 2015 at 07:15 PM
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