(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


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=466041