Stupid excel question, yes i am a dumbo

Vegeta

Ok I want to do the follwoing in excel but its driving me nuts cos I cant do it.

I want to take the numerical contents (whole numbers) of two cells add them and go to the resulting cell number in a different known column. Take the data which is in this known column and print the contents in another column.

here is a simplified example.

cell A1 contains 6
cell A2 contains 9

Add the contents of A1 and A2: answer = 15

got to cell B15

print contents of B15 in D1.

Does anyone know how I would do this. It seems so simple but I just don't have the know how.

I'd really appreciate your help on this one

c - 13

In the function line for cell D1 write "=B15"

I think thats what you wanted is it ?

Vegeta

c - 13 wrote:

In the function line for cell D1 write "=B15"

I think thats what you wanted is it ?

in D1 i want to get the contents of B15 but i want to do it like =B(A1 + A2). That syntax is not allowed.

I have to include the addition of A1 and A2 aswell in the formula.

Thanks

davidoco

I don't know what your doing with cell B15
but is this what you want

result 6+9=15
if so use =CONCATENATE(A1,"+",A2,"=",A3) where sum is in A3

c - 13

^^^^
What he said

Vegeta

No.

I want to add the contents A1 and A2. So A1 + A2 = 'x' This is used to reference a specific cell in column B

I want to place the current value of cell B'x', lets say the contents of B'x' are 'y' into D1. I want cell D1 = 'y'.

In other words. In cell D1 i would like to type =B(A1+A2), which would place the value contained in B(A1+A2) i.e. 'y' into D1.

davidoco

formulas shown


A B C D

6 1 a =VLOOKUP(A3,B1:C26,2)
9 2 b
=SUM(A1:A2) 3 c
4 d
5 e
etc etc

Vegeta

you the man, thank you.

I am amazed you cant just use the row numbers instead of having to insert the numbers myself, but hey whatever works.

Thanks

cyberbob

Vegeta wrote:

you the man, thank you.

I am amazed you cant just use the row numbers instead of having to insert the numbers myself, but hey whatever works.

Thanks

if i read you right the indirect() function will do the trick for you , all you need to do is form the address as string like ="B"&sum( ...whatever.. ) , then use this as the argument in indirect() , like =indirect("B"&sum( ...whatever.. ) ) .

read up on it.

Dr Pepper

Nice one cyberbob. I've always wondered how you do that.

But why didn't you tell me that 5 years ago?..... Why????