Choosing A Flight Dashboard - Any ideas?

[HelpMeWithExcelPlease]

Hello all,

I am trying to figure out the best way to create a dashboard that will allow me to find the best flights to book.

I have the following raw data:

Airline	Flight #	Depart Date	Depart Airport	Depart Time	Arrival Airport	Arrival Time	Price
United	UA330	09/28	DFW	5:00pm	DEN	6:00pm	$100
American	AA80	09/28	DFW	8:00pm	DEN	9:00pm	$200
Southwest	WN1903	09/28	DAL	6:30pm	DEN	7:30pm	$98
American	A443	10/12	DFW	5:45pm	DEN	6:45pm	$77
Southwest	WN1784	10/12	DAL	8:15pm	DEN	9:15pm	$105
United	UA683	10/12	DFW	6:30pm	DEN	7:30pm	$115
Southwest	WN738	10/01	DEN	4:00pm	DAL	7:00pm	$140
United	UA784	10/01	DEN	4:30pm	DFW	7:30pm	$135
American	AA391	10/01	DEN	6:00pm	DFW	9:00pm	$150
American	AA930	10/15	DEN	3:30pm	DFW	6:30pm	$170
Southwest	WN557	10/15	DEN	5:00pm	DAL	8:00pm	$165
United	UA783	10/15	DEN	7:00pm	DFW	10:00pm	$185

<tbody>
</tbody>

Ideally I would have the dashboard look something like this, where when I input my preferred date to Leave Dallas and Return to Dallas (possibly from a drop down with data validation rules if that makes it easier), then the "Departing Flight", "Returning Flight", and "Total Price" columns will either:

1. Automatically fill with the least expensive flights, with the Total Price calculated
2. Show me what options I have for both Departing Flights and Returning Flights (like a VLOOKUP) and then based off of which flights I choose the Total Price would be calculated

Leaving Dallas?	Return to Dallas?	Departing Flight	Returning Flight	Total Price
09/28	10/01	WN1903	UA784	$233

<tbody>
</tbody>

If there is a better way to display this data that I haven't thought of, or an easier way to generate what I am asking for that you can think then please let me know -- I'm open to any and all ideas! The main thing I am looking for is the cheapest round trip -- timing, airports, and airlines are all secondary criteria.

Thank you in advance to anyone that can help!