Formula to be copied across that accommodates set intervals

[The_Snook]

Morning all,

Another day, another Excel curve ball.

The attached should explain the issue that I'm faced with. Basically I've got two data sets that need to be compared but they are split at different intervals and I require a formula that can accommodate this as it is copied across.

Thanks in advance,

Snook

[Pete_UK]

You could put this in B11:

=INDEX(2:2,COLUMNS($A:A)*4-2)=B6

then copy across.

Hope this helps.

Pete

[The_Snook]

Cheers Pete, much appreciated as always.