Hi Nick. Thanks as always for your help.

I use this formula : =IF(ISNA(INDEX(B4:B12,MATCH(B13,B4:B12,0))),"",B13)

However, I have to keep changing the range on the column manually.

So on line 2, I have B1:B2

When I drag the formula down to the cell below it becomes B2:B3, where I want it to

remain B1 and the B2 must change to B3.