How to link a single cell to several other cells, selecting only one based on a value

[davidd31415]

Hi,

I would like to do something like this:

In column A there is a list of values. Say 5, 10, and 15. In cell B1 there is a single integer value.

If B1 is 1, cell C1 should be 5.
If B1 is 2, cell C1 should be 10.
If B1 is 3, cell C1 should be 15.

How can I link cell C1 to the values in column A, through cell B1?

[Paul]

Hi David,

In this simple example, you could use something like:

=INDEX(A:A,B1)

This assumes the 5, 10 and 15 are in A1, A2 and A3. If not, change A:A to the actual data range, e.g. A4:A6.