increase column b12 rows

[shamsu203]

Hi
in this formula
IF(OR($A$1=$A$6,$A$1=$A$10),Data!$J$15,0) when i copy the formula across i wnat to increase the data j15 by 12 to show j27 . the formula starts from b6. i am just making the worksheet as do not have a sample. so b6 will show vale of data j15 c 6 should show value of data j27 and so on

shamsu

 

[shamsu203]

What actually want now.

I want use the name range for the j cell

 

[kvsrinivasamurthy]

In B6 copied across. Range name global.

=IF(OR($A$1=$A$6,$A$1=$A$10),INDEX(global,14+12*(COLUMNS($B$6:B$6)-1)),0)