View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] domenic22@sympatico.ca is offline
external usenet poster
 
Posts: 14
Default Using the returned value to look up an item

On Oct 31, 10:22 am, 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


Try...

=INDEX(B:B,A2)

....where A2 cotains 233.

Hope this helps!