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

  • Thread starter Thread starter Flash in the Pan
  • Start date Start date
F

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
 
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
 
Back
Top