Array formula only pulling back half of the results

PLEASE HELP...I am working on a dashboard, but instead of a Vlookup, I need an array formula because I have data with multiple matches.

I have written the formula and gotten it to pull some of the correct data, but it isn't pulling everything.

So for example, I have a name that I know for a fact has two data points that correspond with the single name, but when I enter the formula it only pulls the second one not the first. If I drag it down, it then starts to pull other peoples data points which I do not want. I have a data validation drop down where I can select the persons name and then it will auto populate based on that.

Could someone please help me get it to only pull the BOTH data points associated with the name selected at the time?

Formula:

=IF(ISERROR(INDEX(Sheet1!$B$1:$C$2649,SMALL(IF(Sheet1!$B$1:$B$2649=TRIM($B$10),ROW(Sheet1!$B$1:$B$2649)),ROW(Sheet1!B:B)),2)),"",INDEX(Sheet1!$B$2:$C$2649,SMALL(IF(Sheet1!$B$1:$B$2649=TRIM($B$10),ROW(Sheet1!$B$1:$B$2649)),ROW(Sheet1!B:B)),2))

Attach a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.