Check if a list of values exist in a specific column

[willow1985]

Hi everyone,

I remember there being a formula that could verify if a list of values existed in a column but cannot remember the formula and have been having difficulty finding it online.
Any help would be appreciated. I included an example of what I am looking for below (formula I am looking for would be in the yellow column).

Thank you to anyone who can help!

Book3
	A	B	C	D	E	F
1	Date	Part #	Description		Part # to look for:	Found in Column B:
2	05-Jan	8821	Gear		ACT3371	Yes
3	23-Dec	y32-AXX3429OXX	Rotor		AXX3429	Yes
4	05-Nov		Nozzle		ARD1289	No
5	11-Jan	XX90ACT3371-7020	Break		AFI5230	No
Sheet1

 

[Tom Urtis]

Try this in cell F2 and copy down as needed. Adjust for actual rows in column B.

=IF(COUNTIF($B$2:$B$100,"*"&E2&"*")>0,"Yes","No")

 

[willow1985]

Try this in cell F2 and copy down as needed. Adjust for actual rows in column B.

=IF(COUNTIF($B$2:$B$100,"*"&E2&"*")>0,"Yes","No")

This is perfect! Thank you very much