Excel - how to look up a table for two values and return another value if these two values match

Excel - how to look up a table for two values and return another value if
these two values match

I hope I am explaining this clearly.
I have sample data 1, but I need this to automatically populate required
sample data with the employee name
Sample data 1:
EmployeeName Type Result
A Annual Exceeds
B Biennial Warning
C Biennial DevelopmentNeeded
D Biennial PartiallyMeets
E Annual Meets
Required sample data: needed to provide an overall summary
PartiallyMeets Meets Exceeds DevelopmentNeeded
Warning
Annual A
Annual E
Annual
Biennial B
Biennial C
Biennial D
I've tried IFERROR, INDEX and MATCH combinations but I haven't had any
success.
Appreciate any help you can provide!! Thanks.