Pull a user-defined season from a date?

7

So I want to pull a season from a date. I have a seasons table and it goes a little like this.

Jan = Low (low/mid/high = season)
feb = low
mar = low
apr = mid
may = mid
jun = high
jul = high
aug = high
sep = mid
oct = mid
nov = low
dec = low

What I want to do is to display a season from the date: 15/07/2016

All help is appreciated, thank you

Sean

Posted 2016-01-04T20:56:59.883

Reputation: 73

Answers

17

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

Máté Juhász

Posted 2016-01-04T20:56:59.883

Reputation: 16 807

Thank you so much! Yeh i knew it was something along those lines but i was really struggling to think what i could do. Only just started my A level course so still learning. Thanks for the help! – Sean – 2016-01-04T21:10:38.887

Asked: 2016-01-04T20:56:59.883

Viewed: 1 136 times

Active: 2016-01-05T12:04:27.460