Index & Match Formula +1 Increments

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
Site C Mr AA

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

I only want the dataset for Site B.

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

Hi

Try the following, I have placed the formula in D2:

Formula:

Please Login or Register  to view this content.

It has almost worked guys so thank you for your help so far. The formula I used is: =INDEX(B:B,MATCH("Site B",A:A,0)+ROWS($1:1)-1,1) This gave me the following results:

MR C
MR D
MR E
MR F
MR AA

The only incorrect outcome was "MR AA" as this belongs to Site C opposed to Site B.

Can anyone help me amend my formula please to only include Site B Data?

It worked! Thank you.