one way:

E10: =IF(COUNTIF(C:C,A10),"",A10)
F10: =IF(E10="","",B10)


In article ,
Ingeniero1
wrote:

(I searched, but the key words yield way too many non-related hits)

I have two lists, A10:B400 and C10:D300. All the sets of data in CD (a
name and a number respectively) are in AB, but AB, obviously, has more
sets of data than CD.

Is there a function, which I can enter in E10:E400, for example, that
will compare each value in A with _all_ the values in C, and if the A
value is not in C, it will write the missing value(s) in E (and F), in
the same row as the A 'source'?

What I trying to find are the sets of data in AB that are not in CD.

Please let me know if I didn't make my query clear enough...

Thanks
alex