Max, thanks, maybe something are meant to be done manually....
cheers.

"Kikkoman" wrote:

Thanks in advance,

Data:
------data 1------ --------data 2------
col A col B col C col D
yum 180 yum 180
yum 200 yum 630
yum 430
yum 832
yum 330

Objective: Match data 1 to data 2 and identify errors
Roll 1 - no problems, both names and value matches
Roll 2 & 3 matches of Data 1 matches to roll 2 of data 2 (or vice versa and
it could hv 3 values in matches to 1 value)
Roll 4 - Missing names & values in data 2,
Roll 5 - Missing names & values in data 1, (need to insert into these data
into data1 -highlighted)

I have about 800 rolls of data, trying to match them up one by one is a
freaking nightmare!!! HELP...