show content of particular cell

**lex_ce** · 02-09-2009, 03:21 AM

Hi,

I have 10000 data in my column A. i can genterate random number from 1 to 10000 through function "randbetween". Now i want to display the particular data which column a and row as per that random number. in short i want to display data of "column A row (generated random number) for lucky draw selection.

please help me out

**DonkeyOte** · 02-09-2009, 04:29 AM

Assume the following:

A1:A10000 contains data
B1: =RANDBETWEEN(1,10000)
C1: =INDEX(A1:A10000,B1,1)

If you were only ever returning 1 column it would make as much sense to put the RANDBETWEEN in C1 instead of reference to B1 and remove B1 altogether.

**lex_ce** · 02-09-2009, 05:53 AM

thnax bro. u made my work so easy !!

thanx a ton !!

Originally Posted by DonkeyOte

Assume the following:

A1:A10000 contains data
B1: =RANDBETWEEN(1,10000)
C1: =INDEX(A1:A10000,B1,1)

If you were only ever returning 1 column it would make as much sense to put the RANDBETWEEN in C1 instead of reference to B1 and remove B1 altogether.