Closed Thread
Results 1 to 2 of 2

copy down formula issue

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question copy down formula issue

    Hello again,

    I have a problem with filling down a formula and using the index function

    D3: =IF(AND($GZ$4<=$B3;$B3<=$HA$4);'Sheet 2'!$E$7/$HB$4;0)

    What I want in D4 is:

    D4: =IF(AND($GZ$4<=$B4;$B4<=$HA$4);'Sheet 2'!$E$7/$HB$4;0)

    This is done simply by draging d3 down to d4,

    But my issue is that i want this pattern horizontelly

    E3: =IF(AND($GZ$5<=$B3;$B3<=$HA$5);'Sheet 2'!$E$12/$HB$5;0)

    E4: =IF(AND($GZ$6<=$B3;$B3<=$HA$6);'Sheet 2'!$E$17/$HB$6;0)

    and so on. I know that i should use the index function but i cant seem to get it to work, any solutions?

    I am trying this:
    D3: =IF(AND($GZ$4<=$B3;$B3<=$HA$4);INDEX('Sheet 2'!$E:$E;ROWS($A$1:A1)*5+2)/$HB$4;0)
    But i think this only help the pattern $E$7, $E$12, $E$17

    Best regards!

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: copy down formula issue

    It is better to continue to your previous post since the formulas you want to use came from that thread.
    http://www.excelforum.com/excel-form...ng-urgent.html


    Thread Closed.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy/Paste Issue
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2012, 05:12 PM
  2. copy formula issue
    By skatcb in forum Excel General
    Replies: 4
    Last Post: 05-28-2012, 06:03 PM
  3. I have a <CTL-C> (COPY) issue...
    By jPaulB in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-21-2012, 09:18 PM
  4. Copy/Paste Issue and Formula Help
    By Josh55303 in forum Excel General
    Replies: 0
    Last Post: 07-18-2011, 02:31 PM
  5. Excel 2007 : Copy tab issue ???
    By arangoa79 in forum Excel General
    Replies: 3
    Last Post: 12-09-2010, 12:13 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