Hi all,
The choose function only works with separate values, but not with a range.
I'm looking for a formula that returns the value in a range based on a number.
e.g. CHOOSE(5, A1:A10) should return the value of A5.
I can program it as a function, but I expect there is a standard formula for this...
br,
Ivo
Bookmarks