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]

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]

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]

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

[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]

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

[FDibbins]

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

@ Tony, you staying warm there?

[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!

[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