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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Airline[/TD]
[TD]Flight #[/TD]
[TD]Depart Date[/TD]
[TD]Depart Airport[/TD]
[TD]Depart Time[/TD]
[TD]Arrival Airport[/TD]
[TD]Arrival Time[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]United[/TD]
[TD]UA330[/TD]
[TD]09/28[/TD]
[TD]DFW[/TD]
[TD]5:00pm[/TD]
[TD]DEN[/TD]
[TD]6:00pm[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]American[/TD]
[TD]AA80[/TD]
[TD]09/28[/TD]
[TD]DFW[/TD]
[TD]8:00pm[/TD]
[TD]DEN[/TD]
[TD]9:00pm[/TD]
[TD]$200[/TD]
[/TR]
[TR]
[TD]Southwest[/TD]
[TD]WN1903[/TD]
[TD]09/28[/TD]
[TD]DAL[/TD]
[TD]6:30pm[/TD]
[TD]DEN[/TD]
[TD]7:30pm[/TD]
[TD]$98[/TD]
[/TR]
[TR]
[TD]American[/TD]
[TD]A443[/TD]
[TD]10/12[/TD]
[TD]DFW[/TD]
[TD]5:45pm[/TD]
[TD]DEN[/TD]
[TD]6:45pm[/TD]
[TD]$77[/TD]
[/TR]
[TR]
[TD]Southwest[/TD]
[TD]WN1784[/TD]
[TD]10/12[/TD]
[TD]DAL[/TD]
[TD]8:15pm[/TD]
[TD]DEN[/TD]
[TD]9:15pm[/TD]
[TD]$105[/TD]
[/TR]
[TR]
[TD]United[/TD]
[TD]UA683[/TD]
[TD]10/12[/TD]
[TD]DFW[/TD]
[TD]6:30pm[/TD]
[TD]DEN[/TD]
[TD]7:30pm[/TD]
[TD]$115[/TD]
[/TR]
[TR]
[TD]Southwest[/TD]
[TD]WN738[/TD]
[TD]10/01[/TD]
[TD]DEN[/TD]
[TD]4:00pm[/TD]
[TD]DAL[/TD]
[TD]7:00pm[/TD]
[TD]$140[/TD]
[/TR]
[TR]
[TD]United[/TD]
[TD]UA784[/TD]
[TD]10/01[/TD]
[TD]DEN[/TD]
[TD]4:30pm[/TD]
[TD]DFW[/TD]
[TD]7:30pm[/TD]
[TD]$135[/TD]
[/TR]
[TR]
[TD]American[/TD]
[TD]AA391[/TD]
[TD]10/01[/TD]
[TD]DEN[/TD]
[TD]6:00pm[/TD]
[TD]DFW[/TD]
[TD]9:00pm[/TD]
[TD]$150[/TD]
[/TR]
[TR]
[TD]American[/TD]
[TD]AA930[/TD]
[TD]10/15[/TD]
[TD]DEN[/TD]
[TD]3:30pm[/TD]
[TD]DFW[/TD]
[TD]6:30pm[/TD]
[TD]$170[/TD]
[/TR]
[TR]
[TD]Southwest[/TD]
[TD]WN557[/TD]
[TD]10/15[/TD]
[TD]DEN[/TD]
[TD]5:00pm[/TD]
[TD]DAL[/TD]
[TD]8:00pm[/TD]
[TD]$165[/TD]
[/TR]
[TR]
[TD]United[/TD]
[TD]UA783[/TD]
[TD]10/15[/TD]
[TD]DEN[/TD]
[TD]7:00pm[/TD]
[TD]DFW[/TD]
[TD]10:00pm[/TD]
[TD]$185[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Leaving Dallas?[/TD]
[TD]Return to Dallas?[/TD]
[TD]Departing Flight[/TD]
[TD]Returning Flight[/TD]
[TD]Total Price[/TD]
[/TR]
[TR]
[TD]09/28[/TD]
[TD]10/01[/TD]
[TD]WN1903[/TD]
[TD]UA784[/TD]
[TD]$233[/TD]
[/TR]
</tbody>[/TABLE]

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!