View original (French)

Add a word if value is present in a list

Solved
vincentltlt -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello

I have been working on a problem for a few hours without finding a satisfactory solution.

My issue is as follows:

In my Sheet 1, I have a list of brands A2:A36, let's say from suppliers.
In my Sheet 2, I have a report.

In Sheet2 column A, I have names of even more suppliers, including those present in Sheet1!A2:A36

In column B of Sheet 2, there are values, and C too

I want to know how to show in cell D2 of Sheet 2 a mention if one of the supplier names matches.

For example, if the supplier JEANMICHEL is present in SHEET1!A1:A36, and we find it in SHEET2!A1:A60, then put "OK" in cell D2, otherwise "NOT OK"

I hope I am clear..!

Thank you very much!

1 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
in D2 to draw on height up to nD60:
=IF(COUNTIF(SHEET1!$A$1:$A$36,A2),"OK","NOT OK")
cheers

--
The quality of the answer mainly depends on the clarity of the question, thank you!
3
vincentltlt Posted messages 2 Status Membre
 
Thank you very much!
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
No problem
I consider the topic resolved
Safe travels
best regards
0