My excel/ google sheet contains multiple columns - Departure City, Arrival City, Flight options, Dep date, Dep time, Fare (one way), Fare (round trip), and etc
Many travel sectors are offered to choose from in the drop down menus. Each and every travel sector offered are having different data on those columns
The question is that;
Let’s say if someone select any travel sector, say from Singapore to Tokyo, how can I bring rest of the relevant data such as the relevant flight no, dates and fares from the excel/ google sheet
Airlines spend millions with database software companies to do this...
Google Sheets is not the best medium to use for this, you would need, as a minimum, a relational database such as mySQL or sqlite (backend on server) to handle the complex queries required. You would probably also need to run a local database (sqlite) on your device.