Thread: Using the returned value to look up an item
View Single Post
  #5   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
That just produces a text value, not the contents of the desired cell...

In article ,
Teethless mama wrote:

="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