Excel

The only Excel tutorial you need in your life:

https://www.youtube.com/watch?v=0nbkaYsR94cwww.youtube.com

Using the INDEX() and the MATCH() functions

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