# copy down formula issue

1. ## 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. ## 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

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

#### 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