choose+match!!

[pierre]

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

 

[Pete_UK]

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