I am using the following formula to check if a contact's job title, stored in cell K5, is found in a named range of job titles.
SUMPRODUCT(--ISNUMBER(SEARCH(LeadershipTitles,K5)))>0
The problem is that this formula returns TRUE when the value in K5 is "Sales Coordinator" but that text (i.e., "Sales Coordinator") is not present in the named range LeadershipTitles (contents of that range listed below).
Any ideas?
Leadership Titles
[TABLE="width: 137"]
<colgroup><col></colgroup><tbody>[TR]
[TD]C.E.O.[/TD]
[/TR]
[TR]
[TD]C.F.O.[/TD]
[/TR]
[TR]
[TD]CCO[/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]CF)[/TD]
[/TR]
[TR]
[TD]CFO[/TD]
[/TR]
[TR]
[TD]Chief Bottle Washer[/TD]
[/TR]
[TR]
[TD]COO[/TD]
[/TR]
[TR]
[TD]EPO[/TD]
[/TR]
[TR]
[TD]EVP[/TD]
[/TR]
[TR]
[TD]Executive Director[/TD]
[/TR]
[TR]
[TD]Executive Manager[/TD]
[/TR]
[TR]
[TD]Executive Sales[/TD]
[/TR]
[TR]
[TD]Founder[/TD]
[/TR]
[TR]
[TD]Genearl Manager[/TD]
[/TR]
[TR]
[TD]General Manager[/TD]
[/TR]
[TR]
[TD]GM[/TD]
[/TR]
[TR]
[TD]Managing Director[/TD]
[/TR]
[TR]
[TD]Managing Partner[/TD]
[/TR]
[TR]
[TD]Officer[/TD]
[/TR]
[TR]
[TD]Owner[/TD]
[/TR]
[TR]
[TD]Partner[/TD]
[/TR]
[TR]
[TD]President[/TD]
[/TR]
[TR]
[TD]Prez.[/TD]
[/TR]
[TR]
[TD]Principal [/TD]
[/TR]
[TR]
[TD]V.P.[/TD]
[/TR]
[TR]
[TD]V/P[/TD]
[/TR]
[TR]
[TD]VP[/TD]
[/TR]
</tbody>[/TABLE]
SUMPRODUCT(--ISNUMBER(SEARCH(LeadershipTitles,K5)))>0
The problem is that this formula returns TRUE when the value in K5 is "Sales Coordinator" but that text (i.e., "Sales Coordinator") is not present in the named range LeadershipTitles (contents of that range listed below).
Any ideas?
Leadership Titles
[TABLE="width: 137"]
<colgroup><col></colgroup><tbody>[TR]
[TD]C.E.O.[/TD]
[/TR]
[TR]
[TD]C.F.O.[/TD]
[/TR]
[TR]
[TD]CCO[/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]CF)[/TD]
[/TR]
[TR]
[TD]CFO[/TD]
[/TR]
[TR]
[TD]Chief Bottle Washer[/TD]
[/TR]
[TR]
[TD]COO[/TD]
[/TR]
[TR]
[TD]EPO[/TD]
[/TR]
[TR]
[TD]EVP[/TD]
[/TR]
[TR]
[TD]Executive Director[/TD]
[/TR]
[TR]
[TD]Executive Manager[/TD]
[/TR]
[TR]
[TD]Executive Sales[/TD]
[/TR]
[TR]
[TD]Founder[/TD]
[/TR]
[TR]
[TD]Genearl Manager[/TD]
[/TR]
[TR]
[TD]General Manager[/TD]
[/TR]
[TR]
[TD]GM[/TD]
[/TR]
[TR]
[TD]Managing Director[/TD]
[/TR]
[TR]
[TD]Managing Partner[/TD]
[/TR]
[TR]
[TD]Officer[/TD]
[/TR]
[TR]
[TD]Owner[/TD]
[/TR]
[TR]
[TD]Partner[/TD]
[/TR]
[TR]
[TD]President[/TD]
[/TR]
[TR]
[TD]Prez.[/TD]
[/TR]
[TR]
[TD]Principal [/TD]
[/TR]
[TR]
[TD]V.P.[/TD]
[/TR]
[TR]
[TD]V/P[/TD]
[/TR]
[TR]
[TD]VP[/TD]
[/TR]
</tbody>[/TABLE]