+ Reply to Thread
Results 1 to 9 of 9

Can cell reference inside formula be derived from another cell?

  1. 11-07-2014, 01:20 PM #1
    kmarie630
    kmarie630 is offline
    Registered User
    Join Date
    06-23-2009
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    16

    Can cell reference inside formula be derived from another cell?

    Is this possible?

    I want the cell reference inside my formula to be derived from another cell. In this very dumbed down example, if I type a G into the above cell, I want the reference F3 in the formula to be automatically changed to G3.

    excel question2.png


    This question stems from a spreadsheet I have, where I have a bunch of GETPIVOTDATA formulas that, of course, reference pivot tables. And I want to easily change which pivot tables the formulas are looking at, by changing one cell.

    excel question1.png
    Reply With QuoteRegister To Reply
  2. 11-07-2014, 01:25 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Can cell reference inside formula be derived from another cell?

    Hi. Your png files haven't loaded. In any event, they're not much use. Can you post an Excel sheet, showing clearly what you want?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 11-07-2014, 01:26 PM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can cell reference inside formula be derived from another cell?

    For your simple example you could use INDIRECT.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 11-07-2014, 01:30 PM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Can cell reference inside formula be derived from another cell?

    Norie, could you see the PNGs? I think there may be "something up" with my PC, as I can't get the canned replies to work either....
    Reply With QuoteRegister To Reply
  5. 11-07-2014, 01:37 PM #5
    kmarie630
    kmarie630 is offline
    Registered User
    Join Date
    06-23-2009
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Can cell reference inside formula be derived from another cell?

    I don't see the button for attaching files on my reply here. But I do see the button on brand new threads that I start... so I guess I have to start a new thread?
    Reply With QuoteRegister To Reply
  6. 11-07-2014, 01:39 PM #6
    kmarie630
    kmarie630 is offline
    Registered User
    Join Date
    06-23-2009
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Can cell reference inside formula be derived from another cell?

    What about now, can you download this spreadsheet?

    test.xlsx
    Reply With QuoteRegister To Reply
  7. 11-07-2014, 01:46 PM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Can cell reference inside formula be derived from another cell?

    Woo Hooo!!!! I can see it... However, you need to point me towards the cells where you want the formula changed...
    Last edited by Glenn Kennedy; 11-07-2014 at 01:49 PM.
    Reply With QuoteRegister To Reply
  8. 11-07-2014, 01:48 PM #8
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can cell reference inside formula be derived from another cell?

    Glenn

    I could see the pictures, which browser are you using?
    Reply With QuoteRegister To Reply
  9. 11-07-2014, 01:52 PM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Can cell reference inside formula be derived from another cell?

    IE 11, and the canned replies were fine a couple of days ago. I (or "she who must be obeyed") may have mashed some keys randomly to cause a problem, but I don't know what they were...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation against cell where value is derived from a formula
    By brian_2me in forum Excel General
    Replies: 1
    Last Post: 04-14-2014, 04:53 PM
  2. [SOLVED] Calling string inside cell reference to reference another sheet.
    By {=OR(value=array)} in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 04:45 PM
  3. How run a Macro if cell E1 equals a value derived from a formula
    By StevePete in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2013, 02:00 PM
  4. How run a Macro if cell A1 equals a value derived from a formula
    By Stickleback in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2012, 01:39 PM
  5. Like to copy cell based on value derived from Formula
    By Leo2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 11:22 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1