one number from multiple columns

[dealer]

Hello,

I have data in columns A2:DK31 and growing,
what i need is to pick a random number from 3 columns ei column A,E,AF.
I know i can use
=index(a2:a31,randbetween(2,31)) to get a random number from column A

but how do i add in column E,AF to this and still return just 1 random number.
Each day there is a new column added and each day he looks for a different combination.

any help is fantastic.

[WHER]

=index(a2:af31,randbetween(1,30),choose(randbetween(1,3),1,5,32))

[Cheeky Charlie]

=index(a2:a31,randbetween(2,31))

Would not work as you hope... it would never return the entry in a2 and would error out 1 in 31 times (looking for item 31 in a list of 30 items).

Index can take an argument for a row and a column - it gives you a hint about this when you type =index(

Something like this would work:
=index(a2:dk31,randbetween(1,rows(a2:dk31)),randbetween(1,columns(a2:dk31)))

this could be improved further, let us know how it goes

PS, um, WHER paid more attention than me...

=index(a2:af31,randbetween(1,rows(a2:af31)),choose(randbetween(1,3),1,5,32)))

[dealer]

Thanks Wher & Cheeky charlie,

Your solutions work great,till the next time.