+ Reply to Thread
Results 1 to 4 of 4

Need to return cell reference from another cell

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    Canada
    MS-Off Ver
    Office 1
    Posts
    5

    Need to return cell reference from another cell

    For example, let's say that A1 is referencing B1. Thus, the formula in A1 is ="B1". I would like to have A2 return the referenced cell of A1, namely A2 ="B1". I don't know if INDIRECT or ADDRESS are helpful (just discovered them today), but I would appreciate some help in trying to figure out a way to do this! Thanks!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Need to return cell reference from another cell

    You can do this by taking advantage of the old XL4 macros that are still coded into the spreadsheet from decades ago.

    Go to Formulas->Name Manager
    Make a new magic word
    Refers To:
    =GET.CELL(6,OFFSET(INDIRECT("RC",FALSE),0,-1))

    That -1 means wherever you type your magic word, it will pull the formula of the Cell 1 row left. Adjust as needed.

    This poster does a good job of explaining everything, and includes pictures.

    http://stackoverflow.com/questions/9...ll-without-vba
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need to return cell reference from another cell

    If you happen to be using Excel 2013 it has a new function to do this:

    A1 = some formula

    =FORMULATEXT(A1)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need to return cell reference from another cell

    Another option is this UDF...

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 05-17-2014, 06:28 AM
  2. Return cell value 30 cells after reference cell
    By shshsh in forum Excel General
    Replies: 8
    Last Post: 04-01-2014, 11:57 PM
  3. Replies: 2
    Last Post: 05-07-2012, 12:20 PM
  4. [SOLVED] UDF to return string of values of all rows with cell matching reference cell
    By oemgacaesar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2012, 12:43 PM
  5. VLOOKUP to return Cell reference rather than Cell Contents.
    By Wozza147 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2009, 07:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1