=CHOOSE(IF(ISERROR(MATCH("X",F7,0)),0,MATCH("X",F7 ,0))+IF(ISERROR(MATCH("Y",F7,0)),0,MATCH("Y",F7,0) *2),5,6)

Because MATCH returns the position of the character within the text being
searched, X and Y have to be the first character in F7 for this to work. If
F7 will always have only a capital X or capital Y, you could use

=CHOOSE(--(EXACT("X",F7))+--(EXACT("Y",F7))*2,5,6)

but the other formulas I sent are much more straightforward and give the
same output.

Hutch

"pierre" wrote:


isnt it possible to combine 2 fonction of : choose and match ????




formula in cell k7 :
=CHOOSE(MATCH("X",F7:F7:F7,0),5)

which means :f there is the letter X in cell F7, then give me the answer 5.

SO NOW....WHAT SHOULD I DO IN ORDER TO HAVE THE FOLLOWING ORDER :

f there is the letter X in cell F7, then give me the result 5 , and if
there is the letter Y give me the result 6 ????

THANKS