choose function challenge

**marcmarc** · 11-17-2006, 03:56 PM

If the index of the choose function is greater than the number of arguments, I need the function to return the last argument and not an error value.

Ex : Choose(index, value1,value2,value3) where index is equal or greater than 4. Then I want choose to return value3 and not #value!
Can this be done with choose, or is there an alternative?

**VBA Noob** · 11-17-2006, 05:25 PM

Does this help

=IF(ISERR(CHOOSE(COUNTA(E7:E9),"value1","value2","value3")),"value3",CHOOSE(COUNTA(E7:E9),"value1","value2","value3"))

VBA Noob

**marcmarc** · 11-18-2006, 01:36 PM

Awsome! Just awesome!
Thank you ! I really appreciate you (VBA Noob) and all of you, taking the time
to help us poor souls with only computer level 1 brains... LOL
Marc