Ok, so this may be a little hard for me to explain, so bare with me.

Basically I have one sheet with a lot of data.

Column A has a 'group' identifier where 10-20 rows may have the same group, and another 10-20 later may have a different group.

On another sheet, I have a cell where the group identifier is specified.

On that sheet, I have rows with cells that need to reflect only the rows that match the group identifier with what is specified in another cell on this sheet.

For example... My "datasheet" looks like this:

Group Id Member Name Member Status
101 Jeff Active
101 Greg Inactive
102 John Active
102 Jane Active

Then I have a "groupsheet" that I want to look like this:

Group Id: 101
********* *********
Member Name Status
Jeff Active
Greg Inactive

So it only shows the rows where the group ID matches whatever it is set to (in the above case, 101, which would show only Jeff and Greg).

My actual data is a lot larger than this so I need a formula I can copy and paste and have it reflect the next row. They are all sorted by group.

This is the closest I've come...

The formula where "Jeff" is in my "groupsheet":
Formula: copy to clipboard 
=VLOOKUP($B$1,datasheet!A:C,2,FALSE)


However it always shows the first match (or last if I set it to TRUE), I need it to increment as I paste it down the column.

I've also done these formulas to get the first and last rows that contain the data I need, if I could somehow use the returned values in an INDIRECT function and select a range between the 2 values these return...

Formula: copy to clipboard 
=MATCH($B$1,datasheet!$A:$A,0)

(returns 2 - the first row where A contains '101')
Formula: copy to clipboard 
=MATCH($B$1,datasheet!$A:$A)

(returns 3 - the last row where A contains '101')