I am working with historical commodity prices. I need to look at a date and return a result based 2 criteria.
1. The (commodity) season
2. A date
Here is a sample of the data:
For example, if I had a piece of data from the 11/12 season (field A), with a date of 11/02/2012 (field B), I want the result to be "WH 2012".
Can anyone help with this?