Do a VLOOKUP between two dates, and then return a corresponding value?

[Mr. Snrub]

I am using Excel 2016. I have a table with three columns: "Start Date", "End Date", and "Season". The table looks as follows:
<p>
<table>
<tr>
<th>Start Date</th>
<th>End Date</th>
<th>Season</th>
</tr>
<tr>
<td>1/1/2018</td>
<td>3/19/2018</td>
<td>Winter</td>
</tr>
<tr>
<td>3/20/2018</td>
<td>6/20/2018</td>
<td>Spring</td>
</tr>
<tr>
<td>6/21/2018</td>
<td>9/21/2018</td>
<td>Summer</td>
</tr>
<tr>
<td>9/22/2018</td>
<td>12/21/2018</td>
<td>Autumn</td>
</tr>
<tr>
<td>12/22/2018</td>
<td>12/31/2018</td>
<td>Winter</td>
</tr>
</table>
</p>

So I want the user to enter in a date and then lookup the season (or if it's out of range, output N/A or "Invalid"):

<p>
<table>
<tr><td>7/18/2018</td></tr>
<tr><td>???</td></tr>
</table>
</p>

How do I do this?

 

[sheetspread]

Excel 2010
	A	B	C
1	Start Date	End Date	Season
2	1/1/2018	3/19/2018	Winter
3	3/20/2018	6/20/2018	Spring
4	6/21/2018	9/21/2018	Summer
5	9/22/2018	12/21/2018	Autumn
6	12/22/2018	12/31/2018	Winter
7
8
9	7/18/2018
10	Summer
Sheet3

Cell Formulas
Range	Formula
A10	{=INDEX($C$2:$C$6,MATCH(A9,IF($A$2:$A$6<=A9,IF($B$2:$B$6>=A9,$B$2:$B$6)),-1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Mr. Snrub]

I figured it out by just using the regular LOOKUP function since the dates were sorted. By the way, how did you get that Excel spreadsheet in your post? That looks much better than my HTML table tags.

 

[sheetspread]

https://onedrive.live.com/?id=8CFFDEC0CE27E813!189&cid=8CFFDEC0CE27E813

Download the first folder, extract, then go to file-options-add ins-manage add ins-browse-click on the file wherever you saved it-be sure it's checked in the add ins, and it should appear on the ribbon if you have Excel 2007 or later, otherwise in the tools menu.

To post on the board with it, highlight the range (not too large, there's like a 100 row limit and too many columns are hard to see), then go to add-ins - mrexcel htlml - generate html - go to MrExcel message page and control-V