Hi all,
I have issues. What I want to do, if possible, is reference a particular cell by using the value in another cell. So for example, if I have the following:
A B C
1 9 3
2 8
3 7
4 6
5 5 =WhatIWant
What I want to be able to do is have another cell somewhere else that will reference one of the cells A1:5, and that cell is determined by cell C1. So as it is above, WhatIWant should equal the value in A3 because C1=3, but if I change C1 to a different number, WhatIWant should change as well.
Any ideas?
Bookmarks