embeded if statements alternative-Selecting cell based on a range

HI Guys,

I have a burning question and hate for embedded if statements. Can someone help me with this issue:

I have a tables as below

Period Product
1 A
5 B
15 C
20 D

I have periods one to 20, instead of using embedded if statements is there a simpler way to do this equation?

I want to achieve a final result as below

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A A A A B B B B B B B B B B C C C C C D