Add a helper column to identify matches

=ISNUMBER(MATCH(A1,'Job Titles'!A1:A728,0))

and then do an advanced filter (dataFilterAdvanced Filter) on the TRUE
values from the help column

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anthony" wrote in message
...
I have a database of 8000 records. I have a second list of 728 job titles
which I have to extrapolate from the first list ie i only want the records
from the 8000 which match the job titles from the second list.
What is the best way to do this?