Assume A1:A10 filled with the characters A to J.
I'm looking for a way to return the letter "C" when 3 serves as the index_num BUT I do not want to present all 10 characters in the formula.
I would like to use the range A1:A10 [SIZE="2"][COLOR="Blue"]=Choose(3,A1:A10)[/COLOR][/SIZE] or, if applicable, to name the range as DATA and then use: [SIZE="2"][COLOR="Blue"]=Choose(3,DATA)[/COLOR][/SIZE]
I tried all I know, including INDIRECT - but found no solution [is there any ?]
As I'm familiar with all workarounds - I will appreciate replies that use CHOOSE.
Thanks in advance, Michael