Re: [libreoffice-users] VLOOKUP Problem

On Sat, 2 Feb 2013 08:31:35 -0700, John Meyer
<john.l.meyer@gmail.com> wrote:

> 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?

In column C use

=IF(A1=B1,A1,"")

It tests for column A and B match, returns column A if true, and an
empty cell if false.
-- 
Keith E.
Excrementum casus

-- 
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