Hi!

Try one of these:

=INDEX(A1:A5,C1)

=INDIRECT("A"&C1)

You might want to make sure C1 has a value entered into it:

=IF(C1="","",INDEX(A1:A5,C1))

=IF(C1="","",INDIRECT("A"&C1))

Biff

"septillion" wrote
in message ...

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?


--
septillion
------------------------------------------------------------------------
septillion's Profile:
http://www.excelforum.com/member.php...o&userid=35882
View this thread: http://www.excelforum.com/showthread...hreadid=556762