=ISERROR(MATCH(A1,B$1:B$999,0))
and drag down to check all cells of column A
Those missing will be marked TRUE

HTH
--
AP
"brodiemac" a écrit dans le message de
news: ...
I have a list of people in column A and another in column B. Column A is
longer than column B so I want to extract what names are missing from
column
B into column C. I don't know why I can't seem to get vlookup to work for
this so I'm asking for some help.

HELP!!!!