Name lookup

[Guest]

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!

 

[Trevor Shuttleworth]

One way:

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

or:

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

Regards

Trevor

 

[Guest]

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.

 

[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

 

[Sam]

Could be due to absolute reference v/s relative reference