Hi All,

Formula: =INDEX(B:B,MATCH("Site B",A:A,0)+0,1)

Data:

Sites Full Name
Site A Mr A
Site A Mr B
Site B Mr C
Site B Mr D
Site B Mr E
Site B Mr F

When I drag the following formula down, I would like the increments to change by 1 so for eg. the formula for the cell below would be =INDEX(B:B,MATCH("Site B",A:A,0)+1,1).

The results should be as follows:

Mr C
Mr D
Mr D
Mr E
Mr F

Can you provide a quick solution please? Many thanks in advance.