Name lookup

W

wagz

I have a list of all the users in a certain system in column "A". I have a
list of users that have logged in that same system in the past three months
in column "C". I would like to compare the two columns and have a function
tell me who has not logged in, in the past three months. So basically, if
you don't match between a and c you are going to be deleted. Thanks in
advance!
 
T

Trevor Shuttleworth

One way:

=IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"Dormant","")

or:

=IF(COUNTIF(C:C,A1)=0,"Dormant","")

Regards

Trevor
 
W

wagz

Is does not seem to work. I pasted both formulas and the entire group shows
up as dormant. If it helps, both are email address. Thanks again.
 
T

Trevor Shuttleworth

Worked for me in a simple test. Perhaps you could post some sample data

Also depends on the source of the data. Could there be spaces at the
beginning or end of the data?

Regards
 
Top