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

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

look in the help index for VLOOKUP

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Flash in the Pan" <hotwire999@hotmail.com> wrote in message
news:1144271046.198754.59750@e56g2000cwe.googlegroups.com...
>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
>

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.

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

Jesse...

That was it!!!

Thanks millions!