On Apr 24, 2:05*pm, Claus Busch wrote:
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

HI Claus
Thanks for you suggestion.

I slightly changed what you suggested to

=INDEX($A$1:$A$3|MATCH("*"|$B$1:$B$3|0))

It kinda worked however it gave me the value in A1 even when no
character was inserted.
It seems that the "*" also allows for a blank entry.

Thanks
Eddie