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

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

  • 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 Jan 4 '16 at 21:10

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.