ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help required on a formula. (https://www.excelbanter.com/excel-worksheet-functions/454257-help-required-formula.html)

shrek March 27th 19 06:46 PM

Help required on a formula.
Apologies if in wrong area.

I have the following formula of which links and paste data in column B. What im trying to do is do the same formula so it takes data from BA7 to CC2 and paste in column F

=INDEX($BA$1:$CC$1,ROWS($A$6:A6))&" "&INDEX($BA$2:$CC$2,ROWS($A$6:A6))

I tried changing to whats below but it not working.

=INDEX($BA$7:$CC$2,ROWS($A$6:A6))&" "&INDEX($BA$7:$CC$2,ROWS($A$6:A6))

Any ideas what ive done wrong.


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.