Hi Mark,

Am Sat, 9 Feb 2013 18:40:07 -0000 schrieb Mark:

Sorry Stan you are correct I meant if I enter BT2 in A1 (with the number
part variable) it enters Bob Todd in A2

in A2 try:
=IF(OR(A1={"BT1","BT2"}),"Bob Todd","")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2