Another play to try ..

Assuming the names are in col A, from A1 down
in all 3 sheets named: Accpted, declined, open

In a new sheet:
-----------------
Put in B1:

=IF(OR(ISNUMBER(MATCH(declined!A1,Accpted!A:A,0)), ISNUMBER(MATCH(declined!A1
,open!A:A,0))),ROW(),"")

Copy B1 down as many rows as there are
names in "declined"'s col A, say down to B1000
(i.e. if the last name in "declined" is in A1000)

Put in A1:

=IF(ISERROR(SMALL(B:B,ROWS($A$1:A1))),"",INDEX(dec lined!A:A,MATCH(SMALL(B:B,
ROWS($A$1:A1)),B:B,0)))

Copy A1 down to A1000
(cover the same range as the formula fill in col B)

Col A will return the desired results

Just copy and paste special as values
either in-situ or elsewhere

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"WellsDesign" wrote in message
...
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