+ Reply to Thread
Results 1 to 10 of 10

Error referencing cell in another sheet

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    28

    Error referencing cell in another sheet

    Hello

    In Excel 2013 (I think) I am in cell B4 on Sheet 2 and want to reference the value of cell N15 on Sheet 1 which I have re-titled 'Data Input & Stats". My formula for Sheet 2 cell B4 is: ='Data Input & Stats'!N15 but I get a #REF! error.

    What am I doing wrong?

    Thanks.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,465

    Re: Error referencing cell in another sheet

    Stay in B4, press F2, click to cell N15 of sheet "data Input & Stats" to see what's displaying in formula bar

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Error referencing cell in another sheet

    Quote Originally Posted by bebo021999 View Post
    Stay in B4, press F2, click to cell N15 of sheet "data Input & Stats" to see what's displaying in formula bar
    =AVERAGE(Input1) is the formula in N15. "Input1" is a range name for a range of input values.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,465

    Re: Error referencing cell in another sheet

    Whatever the formula in N15 is, but linking to cell N15 to get it's value.

  5. #5
    Registered User
    Join Date
    04-17-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Error referencing cell in another sheet

    Quote Originally Posted by bebo021999 View Post
    Whatever the formula in N15 is, but linking to cell N15 to get it's value.
    What do you mean by this?

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Error referencing cell in another sheet

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  7. #7
    Registered User
    Join Date
    04-17-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Error referencing cell in another sheet

    Attached is the worksheet containing the sheet 2 reference to N15 in sheet 1 (Data Input & Stats). Thanks in advance.
    Attached Files Attached Files

  8. #8
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Error referencing cell in another sheet

    The sheet isn't named
    Data Input & Stats

    It's Actually named
    1) Data Input & Stats

  9. #9
    Registered User
    Join Date
    04-17-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Error referencing cell in another sheet

    Now I apologize for wasting your time! A good example of why you should never associate with us non-quantitative, non-detail types!!!!

  10. #10
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Error referencing cell in another sheet

    No worries, glad it's sorted.

+ 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: 0
    Last Post: 01-09-2013, 06:58 AM
  2. Replies: 4
    Last Post: 09-23-2011, 03:41 PM
  3. Worksheets & Cell Referencing #REF! Error
    By ebbo in forum Excel General
    Replies: 10
    Last Post: 03-18-2009, 12:36 PM
  4. Cell Referencing Code Error?
    By MPS0525 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-17-2006, 11:45 AM
  5. Cell Referencing Error.
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 09:45 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