LinkBack URL
About LinkBacks
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...
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...
I think you need to explain a bit more ...
Pete
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)
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
Maybe something like this...
=INDIRECT("A"&ROW())
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
doesnt work
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?
doesnt work
Worked for me?Originally Posted by surin526
C2=INDIRECT("A"&ROW())
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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?
i pasted =INDIRECT("A"&ROW()), into a column, it doesnt like this funtion, it asks for function arguments
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.
Did you see my post #9? Thats exactly what I used
@ Tony, you staying warm there?
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
nevermind, i was doing something stupid, was pasting the function at the wrong place.. sorry.. thank you Tony, FDibbins..
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!
Been there, done that!
Glad you got it straightened out.
I think we have all done that at 1 time or another
Thanks for the feeedback
welcome! thank you!
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
Last edited by sandy666; 03-06-2015 at 10:07 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks