+ Reply to Thread
Results 1 to 3 of 3

cell references

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    39

    cell references

    I am using Excel 2003: In cell J6 I have =IF(M_Y1!$X$6="","",M_Y1!$X$6). I would like J7 to be =IF(M_Y1!$X$7="","",M_Y1!$X$7), J8 to be =IF(M_Y1!$X$8="","",M_Y1!$X$8) and so on. If I highlight these cells and drag to the bottom of my column I just get the 3 references repeated lots of times. How can I get my column to go from =IF(M_Y1!$X$6="","",M_Y1!$X$6) to =IF(M_Y1!$X$130="","",M_Y1!$X$130) without having to change the number in each cell? Thanks for your help.
    Last edited by Mrs T; 10-10-2011 at 10:22 AM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: cell references

    The $ sign in front of a row number or column letter makes it "absolute", when you copy down (or across in the case of column letters) it doesn't change - you need the row number (at least) to be "relative" so remove the $ signs in front of the row numbers, i.e. use this formula in J6 and copy that down

    =IF(M_Y1!$X6="","",M_Y1!$X6)
    Audere est facere

  3. #3
    Registered User
    Join Date
    05-06-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: cell references

    Thank you so much - works perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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