If Statement Formula with 1st Character as the determining factor

[easydawg98]

i need a formula to assign a person to an assignment depending on the first letter of the customer's last name

Ticket # Customer Name Employee Assignment
123 Doe, Jon
124 Smith, Robert


Above is a simple version, but employee "Bob" will take assignments where Customer Last names begin with A-L while Allison will take assignments where the Customer Last name begins with M-Z

Any help is appreciated.

 

[Weazel]

maybe something like...

=IF(OR(LEFT(B2,1)={"A","B","C","D","E","F","G","H","I","J","K","L"}),"BoB","Allison")

 

[easydawg98]

that works, thank you. I was using an * on the letter and was not working.

 

[jtakw]

Hi,

Here's a simpler way:

Book1
	A	B	C	D
1	Ticket #	Customer Name		Employee
2	123	Doe, Jon		Bob
3	124	Smith, Robert		Allison
Sheet32

Cell Formulas
Range	Formula
D2	=IF(CODE(B2)<77,"Bob","Allison")