Im hoping someone could help.

Scenario
I have data on airline routes €“ origin, destination and destination region.
For example, origin might be London, one of the destinations is Mumbai and
destination region is Asia. I have created unique origin that user can
select. I would like to create a dynamic report that list the destination and
its region based on user input.

Origin=London
Region Asia Asia EMEA US
Destination Mumbai Malaysia Spain Texas
Data(miles) 10000 15000 2000 20000

There will be instances where a region will not have any destination. The
order would be Asia, EMEA and US for region. Origin, destination and
destination region are on a same data sheet.

I very much prefer to use to use logic/formula instead of VBA as Im really
bad at it. Any suggestions?