Tricky one- I need to compare two lists to determine where an incorrect
letter or number has been entered.
each casehas a set of two intials and an id number comprising a 3 letter and
four digit number. in the example below c1 and c2 come from one list, and c3
and c4 from another. they are not in the same order however.

c1 c2 c3 c4
DK GHB1234 DK GHB1234
GB DAK7654 LM FDE4587
LM SDE4587 GD DAK7654
AS LKS6532 AF LJS6532

this example aboves shows the four most common outcomes.
row 1= row 1 both values match, all good
row 2= row 3 initials don't match, but id number does
row 3=row 2 initials match, one letter in id doesn't
row 4 = row 4 both initials and id don't match, but they are close.

I would prefer not to order the columns, but could do so I guess.
I was hoping to return the position of the match.
sorry about the confusing instructions, I hope that someone might have a
pointer or two.
there are around 400 to test

cheers