Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Formula - Return Cell Reference?

Posted on 2013-11-25
2
Medium Priority
?
589 Views
Last Modified: 2013-11-25
Does Excel have a formula that returns another cell's reference as text (e.g., "A1")? I need the returned value to change if I insert another row or column - for example, if I insert another row and column, the previous example would change to "B2" automatically.
0
Comment
Question by:songwritingcpa
2 Comments
 
LVL 35

Accepted Solution

by:
mvidas earned 2000 total points
ID: 39675460
Hi SWCPA,

You can use a combination of the ADDRESS(), ROW(), and COLUMN() functions:

=ADDRESS(ROW(A2),COLUMN(A2),4)

The "4" means "return the address using relative references for both row and column". Leaving it blank or entering 1 would return $A$2 instead of A2.

Matt
0
 

Author Comment

by:songwritingcpa
ID: 39675469
Works perfectly. Thank you!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question