[libreoffice-users] VLOOKUP Problem

I have two columns.  Column A displays the logon names being used and
Column B contains all possible logons (technically it's on another sheet,
but I'll simplify).  What I want to appear on column C is a list of all
logons that are not being used.  For instance:

COLUMNA:

Frank
Harry
George

COLUMNB
Frank
Harry
Jason
George
Steven


So what I want to appear in column c is:

Jason
Steven


I'd also like this to be dynamic, so as I pull logons and delete them, the
list updates asd well.  I've tried VLOOKUP and got sort of an answer, but
nor quite the one.  Any ideas?

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted