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!
|