countif

[mort1703]

Hi

how do I change the formula below to search for multiple matches
ie column B3 = "ALPHA / BRAVO / CHARLIE"

A3 = ALPHA
A4 = BRAVO
A5 = CHARLIE
A6 = DELTA
A7 = ECHO

A3 / A4 / A5 need to be flagged "a"
A6 / A7 need to be flagged "b"

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]if(COUNTIF(A:A,B3)>0,"a","b")[/FONT]

 

[jtakw]

Hi,

If you mean "ALPHA / BRAVO / CHARLIE" is All in 1 cell, B3:

Book1
	A	B	C
3	ALPHA	ALPHA / BRAVO / CHARLIE	a
4	BRAVO		a
5	CHARLIE		a
6	DELTA		b
7	ECHO		b
Sheet338

Cell Formulas
Range	Formula
C3	=IF(COUNTIF(B$3,"*"&A3&"*"),"a","b")

Formula copied down.