Excel

The only Excel tutorial you need in your life:

Using the INDEX() and the MATCH() functions

=INDEX(Bonuses[Bonus]; MATCH([@Type]; Bonuses[Type]; 0))