Compare cell values to cell range and indicate if value is found

[gvoulkas]

Hi all,
here is my case:
I have a list of users containing the fields: user first name, user last name, and user code.
I also have a list of "success" codes (a range of cells in a column).

I would like my sheet to be able to check for each user in the list if his code is found in the "successful" codes list, and if yes, to provide either some sort of an indication in an adjacent column or a different formatting that would pinpoint (or filter) the "successful" users.

I am attaching a sample file. Bookgv.xlsx

Thanks in advance for your support!

[Fotis1991]

Hi and welcome to the forum. Are you Greek(Είσαι Έλληνας)?

Try this in D3 and copy down,

=IF(COUNTIF($G$3:$G$7;A3)=1;"OK";"no")

Is this, works for you?

[gvoulkas]

Hi and welcome to the forum. Are you Greek(Είσαι Έλληνας)?

Try this in D3 and copy down,

=IF(COUNTIF($G$3:$G$7;A3)=1;"OK";"no")

Is this, works for you?

excellent! it worked fine!
thank you very much for the accurate answer and the fast response!

(έλληνας είμαι - σε ευχαριστώ πολύ!)

[Fotis1991]

You are welcome!

Χαίρομαι όταν συναντώ Έλληνες στο Φόρουμ. Γινόμαστε πολλοί σιγά-σιγά.

[gvoulkas]

Πραγματικά δούλεψε μια χαρά.
Μια τελευταία ερώτηση εάν έχεις χρόνο:
η λίστα με τα "success codes" μπορεί να βρίσκεται σε άλλο sheet ή σε άλλο workbook?

Γιώργος