Retrieving multiple results with INDEX MATCH?

The way to do this most efficiently is to NOT use a second tab. Use the original data tab2.

1) Highlight the headers in ROW1
2) Turn on the Data > Filter
3) Use the drop down that created itself in A1 to select the ID you want to review

The filter will hide all other rows. You can select one ID or even several.

With the data filtered you can print, edit, copy to another location (usually not necessary), anything you need, then filter again, or select all to view the entire table again. So the need for Tab1 is pretty much nonexistant.

In B2:

=IFERROR(INDEX('Tab2'!B:B,SMALL(IF('Tab2'!$A$2:$A$10=$A$2,ROW('Tab2'!B$2:B$10)),ROWS($A$1:A1))),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Drag copy across and down.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

You're welcome!

However, as Jerry has pointed out, it would be far simpler to filter the original list!