Get cell number from another Cell value

[goble]

Hello,

I have a column A2 with value "1". I would like the formula in B2 to generate "C1". So if the value of A2 is 1, then B2=C1+5. Where C1 is generated because A2 value is 1. So it is 405.
If value of A2 is 2, then use C2 in generated in formula of B2. Formula at B2 will then be "=c2+5". So it is 505.

		400
1	Formula here is "=c1+5". So it is 405.	500

 

[Fluff]

How about

=INDEX(C:C,A2)+5

 

[etaf]

what if A2 was 12, or 16 ?
can it only be 1 or 2

are the values 400 & 500 already entered into the cell

 

[goble]

Hello and thanks,

If A2 =12, then B2=C12+500
If A2 =16, then B2=C16+500

Yes values of 400 & 500 are already entered.

 

[goble]

How about

=INDEX(C:C,A2)+5

Hello I missed you answer. Actually I simplified what am trying to do.

 

[Fluff]

Actually I simplified what am trying to do.

Then what are you trying to do? That formula will do exactly what you asked for.

 

[goble]

It works perfectly thanks !

 

[Fluff]

Glad we could help & thanks for the feedback.