+ Reply to Thread
Results 1 to 4 of 4

drag offset formula with out changing values

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    17

    drag offset formula with out changing values

    I'm trying to drag the formula horizontally.

    =OFFSET('Data Input'!D655,$AB$2,,,)

    I want the cells to BE UPDATED IN this format

    A1= =OFFSET('Data Input'!D655,$AB$2,,,)
    b1=OFFSET('Data Input'!D656,$AB$2,,,)
    C1=OFFSET('Data Input'!D657,$AB$2,,,)
    D1=OFFSET('Data Input'!D658,$AB$2,,,)
    E1=OFFSET('Data Input'!D659,$AB$2,,,)

    Tried using $ sign E1=OFFSET('Data Input'!$D655,$AB$2,,,)...but it is still not working..Am i missing any thing. ?

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: drag offset formula with out changing values

    I think you need something like:
    =OFFSET(INDIRECT("'Data Input'!$D" & column(A1+654)),$AB$2,,,)

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: drag offset formula with out changing values

    Or, in A1:

    =OFFSET(INDEX('Data Input'!$D:$D,654+COLUMNS($A:A)),$AB$2,,,)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    09-30-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: drag offset formula with out changing values

    is there a typo in this, Its throwin problem with the formula error. I'm not too familiar using indirect with offset..Thanks...

+ 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. [SOLVED] Dynamic offset as you drag formula down/across
    By brad999 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2013, 01:37 PM
  2. Drag Offset Formula
    By gootie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2013, 03:16 PM
  3. How do I click and drag a formula changing only 1 value?
    By scottghansen79 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-25-2010, 07:34 PM
  4. Replies: 3
    Last Post: 06-30-2010, 09:55 PM
  5. What a drag - changing the formula
    By KJG67 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2007, 12:56 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