Comparing Lists

[Andrew Mackenzie]

Hi,

I'm trying to comapre two lists of data and each list has a unique
identifier a bit like this (though much longer):

ColA Col B Col D Col E
12345 ABC 67890 DEF
67890 DEF 85642 XYZ

The fomula I'm using in cell F1 is:

=MATCH(D1,$A$1:A$2,0)

For some reason I'm getting #N/A in F1 even though I can clearly see that
there is a match. The lists come from different sources but as far as I can
tell the formatting of columns A and D are the same.

Please can anyone help?

Many many thanks in advance,

Andrew

 

[David Biddulph]

Perhaps trailing spaces (or other non-printing characters)?
Check =LEN(A2) and =LEN(D1), for example. Also look at =A2=D1 and see
whether it returns true or false.