choose+match!!
 

given :

range A range B range C

range 44 1 b xa

range 45 2 b xb

range 46 3 c xc

range 47 4 d xd

range 48 5 e xe


i want to combine the CHOOSE and MATCH function together in order to get
"a" or "b" or "c" or "d" or "e".....after having typed 1 or 2 or 3 or 4
or 5

choose+match!!
 

Not sure how your table relates to what you want to do - there are
many ways of converting 1, 2 etc into a, b etc. which don't require a
table.

Pete

On Apr 18, 6:31*pm, pierre wrote:

given :

* * * * * * * * * * *range A * * * * * range *B * * * * *range *C

range 44 * * * * * *1 * * * * * * * * * *b * * * * * * * * *xa

range 45 * * * * * *2 * * * * * * * * * *b * * * * * * * * *xb

range 46 * * * * * *3 * * * * * * * * * *c * * * * * * * * *xc

range *47 * * * * * 4 * * * * * * * * * *d * * * * * * * * *xd

range *48 * * * * * 5 * * * * * * * * * *e * * * * * * * * *xe

i want to combine the CHOOSE and *MATCH function together in order to get *
"a" or "b" or "c" or "d" *or *"e".....after having typed *1 *or 2 or 3 or 4
or 5