Absolutely right, JE!

Thanks,

Niek

"JE McGimpsey" wrote in message
...
Just a note - the UCASE()'s are unnecessary in this formula since XL's
comparisons are case insensitive.

See my other post for a different answer - the OP's problem statement
seemed rather ambiguous.

In article ,
Bill Martin wrote:

How about:

=if(ucase(left(A1,4))="DEAN","ADK",if(ucase(left(A 1,4))="DAVE","DJM","MWP"))