Comparing Data lists

[JMFW]

Hi

I have two lists of serial numbers which I want to compare to find those number which are not in both lists. I have used the following formula: =IF(A2=$G$2:$G$283,"",A2) where A2 equals the first cell in list 1, G2:G283 the range of the second list, true value "" false value display the contents of the original cell.

This works so far; where the contents in the A and G cells are the same on the row eg A2 and G2, but where they are different the contents of the A cell are being returned even if they are elsewhere in the range.

Anyone help please.

 

[SteveO59L]

Have a look at vlookup()

 

[ka_123!]

i think there is no need to fixed those

C D
1 1 =IF(D5:D12=C5,TRUE, FALSE) [copy this formula down)
1 2
6 3
4 4
4 5
4 6
2 7
2 8

 

[Trouttrap2]

Here is an additonal way. The formula returns the contents in column A if it is not found in columg G.
=IF(COUNTIF($G$2:$G$7,A2)=0,A2,"") copy down.

 

[JMFW]

Hi

Thanks very much I've use Trouttrap2's solution.