I would like to have a cell (A2) with "H" in it. then have another cell with something like =A2&"2" which would equal H2 and actually reference cell H2? is this possible?
I would like to have a cell (A2) with "H" in it. then have another cell with something like =A2&"2" which would equal H2 and actually reference cell H2? is this possible?
Try this one.
=indirect(a2&2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks