LinkBack URL
About LinkBacks
Please let me know if you can decipher this: INDIRECT($A$1&ROW(A3)-1).
HELP NEEDED: INDIRECT combined with ROW function
Please let me know if you can decipher this: INDIRECT($A$1&ROW(A3)-1).
Yes, I can.
It will return INDIRECT($A$12). Did you need to know anything else about it?
Last edited by AliGW; 05-20-2016 at 12:39 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi -
That formula returns a cell reference based on the text string inside it. I don't think the syntax is quite correct since INDIRECT() expects a text string. I think it should be corrected to be:
=INDIRECT("$A$1"&ROW(A3)-1)
The ROW of A3 is 3. Subtract 1 from that gives you 2. Concatenate that onto the end of "$A$1" gives you $A$12.
This formula will return whatever is stored in cell A12.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
INDIRECT takes a text string and interprets it as a range, then returns that range.
ROW(A3) will always return 3--the row number of cell A3. Then it subtracts 1.
Cell A1 must contain a column identifier, like BD. In that example, your formula would return the contents of cell BD2.
Last edited by 6StringJazzer; 05-20-2016 at 12:32 PM.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Good point 6StringJazzer. I had not interpreted the cell reference that way.
The syntax is correct if cell A1 contains a column reference.Originally Posted by loginjmor
I cannot think of any interpretation of that formula that will produce this result.
It was a typo - I have corrected my post.
Thanks everyone!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks