cell reference based on value in another cell
Posted on 2011-05-11
I think this should be easy, but I can't figure out quite how to do it.
Here is a simple representation
A B C D E
1 2 2
In the cell A6 I need a function that returns the value in A1, A2 or A3 depending on the value of the relevant row in D1.
eg If D1 = 1 A6 is the value in A1. If D1 = 3 A6 is the value in A3. etc
What is the easiest way of indicating a row reference based on the value in a given cell?