Hello,

I'm trying to re-write the following formula without extending it too long each time the year increases. What would be the way of doing it without having to create too many nested if?

Formula: copy to clipboard 
=IF($M2="", "",IF($M2="fy18_cmp", "FY18", IF($M2="fy19_cmp", "FY19", IF($M2="fy20_cmp", "FY20", IF($M2="fy17_cmp", "FY17", IF($M2="fy16_cmp", "FY16", IF($M2="fy21_cmp", "FY21")))))))


Thank you.