Vlookup conditional formatting

[Shinianne]

Hi Great Master of Excel,

Id like to seek help on how i can make this possible.
I need YES or NO to appear on a Cell if the Name is found under opened by using the list on column A
I tried conditional formatting but i couldn't seem to get it. Thank you

Ralph				YES/NO	Number	Opened by	Description	Work notes	Active
Anna					418494	Ralph		asdasd	TRUE
Anna					418463	Anna		sdas	TRUE
Albert					418400	Anna		das	TRUE
Rolando					417915	Albert		das	TRUE
Misheal					418196	Rolando		das	TRUE
Lope					417293	Misheal		sdas	TRUE
Richard					417019	Lope		ASDASd	TRUE
Kirubakaran					416928	Richard		Asd	TRUE
Jesse					416700	Kirubakaran		v AS	TRUE
Ariel					418163	Jesse		ebvge	TRUE
Ariel					417063	Ariel		hne	TRUE
Richard					416870	Ariel		thy	TRUE
Robin					416884	Richard		ner	TRUE
Victoria					416877	Robin		tw	TRUE
Gurprit					417954	Victoria		FC	TRUE
Omprakash					417437	Gurprit		eat	TRUE
Alexander					417160	Omprakash		BZD	TRUE
Christopher					416974	Alexander		FVZDSF	TRUE
Christopher					417054	Christopher		DVZS	TRUE
Joel					416919	Christopher		DFZ	TRUE
Chelsea					418511	Joel		STSZD	TRUE
Chelsea					418197	Chelsea		FVSD	TRUE
Shin					417978	Chelsea		VF	TRUE
Nina
Yasmin

 

[Joe4]

You cannot use Conditional Formatting to return values. It only changes the formatting of a cell.

So, are you saying that you want to look at each value in column A, see if it is found anywhere in column D, and if it is found, return "YES" (otherwise "NO")?

If so, enter this formula in cell B2 (your YES/NO column) and copy down for all rows:

=IF(COUNTIF(D:D,A2)>0,"YES","NO")

 

[Shinianne]

Thank you so much it worked !

 

[Joe4]

You are welcome!