Hi Eddie,

Am Fri, 22 Apr 2011 13:55:59 -0700 (PDT) schrieb webels:

I?m guessing there is no way to allow any character be placed in B1 or
B2 or B3 other than x and still return the values (allowing for users
who fail to use ?x? as instructed)?

for any character:
=INDEX($A$1:$A$3,MATCH("*",$B$1:$B$3,0))


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