Solved

Excel Formula - Return Cell Reference?

Posted on 2013-11-25
2
535 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 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now