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

whe
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

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

look in the help index for VLOOKUP

--
Don Guillett
SalesAid Software

"Flash in the Pan" wrote in message
ups.com...
I have the following:
A B C
1 5 x y
2 7
3 9

whe
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

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

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.

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

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

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

Jesse...

That was it!!!

Thanks millions!