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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
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.
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