| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
choose+match
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| choose match formula | Excel Discussion (Misc queries) | |||
| Help with lookups (Index/Offset/Match/Choose???) | Excel Discussion (Misc queries) | |||
| How can I choose every nth name in a spreadsheet? | Excel Discussion (Misc queries) | |||
| VLOOKUP, INDEX, MATCH... What to choose | Excel Worksheet Functions | |||
| Choose. | New Users to Excel | |||
Threaded Mode
