# Need help writing a Formula

#### Lulu53

##### New Member
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Need help with this problem
In column D I manually input the amount (which is taken from another tab)
(Example) [FONT=&quot]=+'[CCD and B F 2015.xlsx]BNS BC'!Y125! [/FONT]
In column F I want be able to pull the info from “Y126” without having to repeat the above manually.

 [FONT="]Column D[/FONT] [FONT="]Column F[/FONT] [FONT="]0.206346[/FONT]​ [FONT="]Fees[/FONT]​ [FONT="]37.75521[/FONT]​ [FONT="]0.407227[/FONT]​ [FONT="]Fees[/FONT]​ [FONT="]67.12834[/FONT]​

<tbody>
</tbody>

How can I get this result in column F [FONT=&quot]'[CCD and B F 2015.xlsx]BNS BC'!Y126![/FONT]

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
As you havent said what row the values are in...

in F (whatever the row number is)

=IF(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,-3)="","",INDIRECT("[CCD and B F 2015.xlsx]BNS BC'!Y"&INT((ROWS(\$1:1)-1)/2)+125))
and copy down

or if your data starts at D2 then simply

=IF(D2="","",INDIRECT("[CCD and B F 2015.xlsx]BNS BC'!Y"&INT((ROWS(\$1:1)-1)/2)+125))
and copy down

adjust the D2 row as necessary

The values are in row 4

Hello Special-K99

Is it possible for me to send you an attachment so you can see what I am trying to achieve?

Replies
1
Views
738
Replies
9
Views
1K
Replies
1
Views
811
Replies
6
Views
947
Replies
3
Views
1K

1,196,414
Messages
6,015,127
Members
441,874
Latest member
saustark

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back