how to do diagonal lookup

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