Thread: choose+match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default choose+match

=IF(F7="X",5,IF(F7="Y",6,""))

or possibly

=CODE(F7)-83

You didn't say what should be returned if F7 is neither X nor Y.
Hope this helps,

Hutch

"pierre" wrote:

PLEASE HELP ME

i entered the following 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