Excel Reference Formula

[ashliiii]

Suppose I have an Excel sheet with cell A1 = 1000, A2 = 950, A3 = 775, B1 = 625, B2 = 595 and B3 = 410.

If cell A5 = 2, what formula should I type in cell A6, so that A6 = 950 which is the value in cell A2. If I were to type value 3 in cell A5, then cell A6 = 775, the value in cell A3. Thank you for your time.

 

[Kerryx]

Book1
	A	B
1	1000	625
2	950	595
3	775	410
4
5	2
6	950
Sheet1

Cell Formulas
Range	Formula
A6	A6	=INDEX(A1:A3,A5,1)