Multiple Match/Index for Individual Tabs

You can try other formulae than the one I used by searching on google for "excel lookup multiple results".

The one I used is:

http://www.get-digital-help.com/2009...okup-in-excel/

When you apply the formula in your workbook update the ranges. Not sure how well this will work in google sheets though.