Thread: Using the returned value to look up an item
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Using the returned value to look up an item
One way:

=INDEX(B:B,INT(RAND()*371)+1)

In article ,
Frankd410 wrote:

I have a random number from 1- 371
That points to a cell for example
Random number is 233
I want the value of the contents in cell B233

How can I do this
Reply With QuoteReply With Quote