cell's reference value dependent on another cell's value

[Flash in the Pan]

I have the following:
A B C
1 5 x y
2 7
3 9

where:
A1=5, A2=7, A3=9

B1=x
C1=y


I want the value in B1 to be dependent of the value in C1 such that:

If C1=1 then I want B1=A1 (or 5)
If C1=2 then I want B1 =A2 (or 7)
and
If C1=3 then I want B1 =A3 (or 9)

what code or formula do i put in B1 to get tis result?

Thanks

J

 

[Don Guillett]

look in the help index for VLOOKUP

 

[Flash in the Pan]

I did read up on vlookup and it's not quite what I'm looking for.

Vlookup searches one colum for a certain value and returns the value in
the same row from another column.

What I want is to get a certain cell's value in a column and the
"location of the cell" to get the value from is dependent on the value
stored in a certain cell whose location never changes.

Thanks.

 

[Jesse]

Flash, do you want the row the data is pulled from the be pulled from a
different column?

I think what you want is =indirect("A",C1)

Jesse

 

[Flash in the Pan]

Jesse...

That was it!!!

Thanks millions!