Value from another cell but...

  • Thread starter Thread starter Cthulhu
  • Start date Start date
C

Cthulhu

I want a cell to have a value that comes from another cell, but the cell
from which it comes depends on what is in a 3rd cell. I'm not even sure
this is possible

For example

Cells A1 = Hello, A2 = Bye
The value in cell C1 will come from a cell in the A col, but which cell
exactly depends on the value in he cell B1
So if B1 = 1, C1 takes the value from A1 (Hello). Is B1 = 2, C1 = Bye.
If B1 = 15, C1 takes its value in cell A15, and so on.

So is that possible? If so, how do i do that?
 
Back
Top