how to do diagonal lookup

[legolas]

dear all,

i have as per attached fixed figures in C
i am trying to copy from C into B in a way that B4=C3 and so on until the value in A starts a new sequence a new diagonal copy should start in B as maked in grey in B.

Any help is appreciated

thank you

[Marcol]

Maybe in B2

Please Login or Register  to view this content.

Drag/Fill down

[EDIT]
Added attachment to test the forum facility .... fingers crossed.

@legolas see the conditional formatting

[legolas]

excellent as usual

thanks a lot