Return multiple columns with vlookup when there are multiple matches

I have a sheet with three columns. Within column B there are 10 distinct types, however, column A can have duplicate values. I am trying to get the corresponding value for each name within A should the type in column B match on a separate sheet. The formula I have is as follows:

=IF(VLOOKUP($A2,Sheet1!$A:$C,2,FALSE)=B$1,(VLOOKUP($A2,Sheet1!$A:$C,3,FALSE)), "")

With the if test changing from B-K for each type I am trying to match. However, it is only returning the first match and not any subsequent matches.

This is representative of the table for vlookup:

Name Type Cost
#1 Eric 360 DB $2.00
#1 Eric Cert $8.50
#1 Eric Self $14.00

And this for the results:

Name 360 DB Cert Self
#1 Eric 2.00 8.50 14.00