Index Match Problem for multiple matches

Hello all,

I have a excel sheet which allows me to select a rep in cell G2 and then I use Index/Match formulas to help me find all the data on that person. The problem i am having is that my index formulas are not working correctly. Either it gives me N/A# or wrong info.
Here is my formula:

=INDEX(Sheet1!A$2:A25,MATCH($G$2,Sheet1!$B$2:$B$250,0))


I have attached my excel sheet as well.


Thanks

In Sheet1, add a helper column with formula in G2:

=IF(B2=Sheet2!G$2,COUNT(Sheet1!G$1:G1)+1,"")

copied down.

Then in Sheet2, A2:

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROWS($A$1:$A1),Sheet1!$G:$G,0)),"")

copied down as far as you want and across

Hi,

I couldn't see any #N/A results on your workbook. However rather than using functions to try and extract records like this you should be using Data Filtering. Either Data Filter on the list itself or use Data Filter Advanced to extract a separate list based on your G2 criteria.

Rgds