How to turn a string into a formula?

  • Thread starter Thread starter rocky
  • Start date Start date
R

rocky

I want to reference another sheet's cell contents based on a randomly
generated row number. So I do the following:

Say cell B1 has the formula "=INT(RAND()*10)" to generate a random row
number. Say the generated random number is 5.

Based on this I try to get the cell contents from another sheet with
this equation => ="Sheet1!A" & B1

But this formula ends up returning the string "Sheet1!A5" which is
correct, but like I said it returns a string and not a formula to grab
the cell contents of another sheet.

Anyone know how to make this string a formula?

tia, Ray
 
Back
Top