Value from another cell but...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show other cell if blank 5
Conditional Formatting, Icons 1
reffering another cell value which contains RAND() 0
Stop Rounding Currency 20
Parsing help requested 3
Excel In Excel how can I block the contenent of a cell? 0
Cell colour change if formula displays false 3
how to date 4

Top