row function question

[surin526]

hi,

if row A2 has the value 45 how to get the 45 ? without specifying A2 ?
i need to get the 45 from another cell in the same row...

[Pete_UK]

I think you need to explain a bit more ...

Pete

[surin526]

say A2 has the value 45, A10 has the value 100
want to be able able to get the value 45 in another column on the same row as A2
want to be able to get the value 100 in another column on the same row as A10

want a generalized formula not =ROW(A2) or =ROW(A10)

[surin526]

trying something like =INDIRECT("Baselines!C"&2+(8*(A(=ROW())-1))) , although this is an invalid function
idea is =ROW() would give me say 10 , then A10 would give me 100

[Tony Valko]

Maybe something like this...

=INDIRECT("A"&ROW())

[surin526]

doesnt work

[Tony Valko]

That formula will return the cell value from column A based on what row the formula is entered on.

If the formula is entered in Z10 then the reference will be to A10.

If the formula is entered in D22 then the reference will be to A22.

If the formula is entered in BA401 then the reference will be to A401.

Isn't that what you wanted?

[surin526]

doesnt work

[FDibbins]

doesnt work

Worked for me?

	A	B	C
2	10		10
3			0
4			0
5			0
6	20		20

C2=INDIRECT("A"&ROW())
copied down

[surin526]

say A2 has the value 45, A10 has the value 100
want to be able able to get the value 45 in another column on the same row as A2
want to be able to get the value 100 in another column on the same row as A10

want a generalized formula not =ROW(A2) or =ROW(A10)

[FDibbins]

say A2 has the value 45, A10 has the value 100
want to be able able to get the value 45 in another column on the same row as A2
want to be able to get the value 100 in another column on the same row as A10

want a generalized formula not =ROW(A2) or =ROW(A10)

This is a direct copy of your post #3. If we didnt understand from that, I doubt repeating the same thing will change anything?

[surin526]

i pasted =INDIRECT("A"&ROW()), into a column, it doesnt like this funtion, it asks for function arguments

[Tony Valko]

The formula I suggested does what you want.

Maybe give us some more details as to what cells you're entering the formulas in and what results you're getting.

[FDibbins]

Did you see my post #9? Thats exactly what I used

@ Tony, you staying warm there?

[surin526]

as of now in A2 i have the value 2.
On E2 , i tried to enter =INDIRECT("A"&ROW())
it doesnt seem to accept this function

[surin526]

nevermind, i was doing something stupid, was pasting the function at the wrong place.. sorry.. thank you Tony, FDibbins..

[Tony Valko]

@ Tony, you staying warm there?

Yeah, it was -4° this morning but warmed up to 21° this afternoon.

Supposed to warm up to our normal temps (40's) over the weekend. That's gonna seem like a summer day!

[Tony Valko]

i was doing something stupid..

Been there, done that!

Glad you got it straightened out.

[FDibbins]

nevermind, i was doing something stupid, was pasting the function at the wrong place.. sorry.. thank you Tony, FDibbins..

I think we have all done that at 1 time or another

[FDibbins]

Thanks for the feeedback

[surin526]

welcome! thank you!

[sandy666]

if A2 = 45 and A10 = 100 and you want get value of A2 (45) in another cell use something like that: =$A2 (i.e. in cell D5) and you will see value 45 in cell D5


edit:
ups, not marked post, sorry