Referencing a cell based on the value in another cell

Giganews Newsgroups
Subject: Referencing a cell based on the value in another cell
Posted by:  septillion (septillion.2a59wn_1151552402.2132@excelforum-nospam.com)
Date: Wed, 28 Jun 2006

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?action=getinfo&userid=35882
View this thread:http://www.excelforum.com/showthread.php?threadid=556762

Replies