Thread: Using the returned value to look up an item
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Using the returned value to look up an item
="B"&RANDBETWEEN(1,371)

Required ATP add-ins


"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