Pull a user-defined season from a date?

You can easily do it with VLOOKUP, just insert a new column with column numbers, then use this formula:

=VLOOKUP(MONTH(E2),A:C,3,FALSE)

enter image description here