Fill previous and next Cells based on middle cell

Great.... works fine.... Thanks Shiju.

Originally Posted by Shijesh Kumar

use this in B!

=INDEX(Heads,IF(MATCH(B2,Heads,0)-1=0,9,MATCH(B2,Heads,0)-1),1)

and this is b2

=INDEX(Heads,IF(MATCH(B2,Heads,0)+1=10,1,MATCH(B2,Heads,0)+1),1)