I have a data table which lists the season (column a) and then its start and end times for astronomical (columns B & C) and meteorological (columns D & E). In another spread sheet, the user will be entering the type of season which can be either astronomical or meteorological and then the season in the yellow boxes. Based on these inputs, I would like to access the data table and grab the appropriate begin and end dates for those selections. Does anyone have any ideas of how I can do this? I have included a spread sheet to show you what I mean.
Thanks for any help!
Jeff