Thread: choose+match!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default 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