Use the vlookup function to check if the name in the open list is also in the
accepted list.
HTH,
Gary Brown


"WellsDesign" wrote:

I have a list of 3000 names from 3 diffrent lists. (Accpted, declined, open)
I want to get a list of all the declined names that also appear on the open
or won lists. how do I do this?
Using Excel 2002