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?

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

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?

Hi Eduardo

User can select from a dropdown list of unique origin (selected London as an
input). The output is shown below with Region, Destination and Data on the
left and the result are the right. Hope this clarify.


"Eduardo" wrote:

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

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?

hi
Let's say it choose London, he has to choose one of the regions option and
cities in order to get the milage, or you want all the options to show up at
once

"C02C04" wrote:

Hi Eduardo

User can select from a dropdown list of unique origin (selected London as an
input). The output is shown below with Region, Destination and Data on the
left and the result are the right. Hope this clarify.


"Eduardo" wrote:

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

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?

All the options to show up at once.

"Eduardo" wrote:

hi
Let's say it choose London, he has to choose one of the regions option and
cities in order to get the milage, or you want all the options to show up at
once

"C02C04" wrote:

Hi Eduardo

User can select from a dropdown list of unique origin (selected London as an
input). The output is shown below with Region, Destination and Data on the
left and the result are the right. Hope this clarify.


"Eduardo" wrote:

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

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?

So, let's say you have the table as follow
Sheet2 Column A: Origin, Region, destination & Miles
Sheet2 Column B, c, d, Etc the information related to Region, destination &
miles(your example, column B will be Asia, mumbai, 10000)
En Sheet1 you want to pull this information when an origin is selected let's
say in A
in A2 you will right Region, in A3 Destination, in A4 data(miles)
in B2 enter this formula
=+VLOOKUP($A2,Sheet2!$A$:$F$,2,FALSE), then in C2 Change the 2 for 3, and so
on that numbers identify the column where to pull the information
Then copy the formula down and you will have the expected results

"C02C04" wrote:

All the options to show up at once.

"Eduardo" wrote:

hi
Let's say it choose London, he has to choose one of the regions option and
cities in order to get the milage, or you want all the options to show up at
once

"C02C04" wrote:

Hi Eduardo

User can select from a dropdown list of unique origin (selected London as an
input). The output is shown below with Region, Destination and Data on the
left and the result are the right. Hope this clarify.


"Eduardo" wrote:

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

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?