Is it possible to create two drop downs in the first tab and then compare that data to another tab with 3 columns and then copy the data from a third column.
Tab 1 will have a 2 drop downs
- Dropdown A: Origin
- Dropdown B: Destination
Tab 2 will have the following example columns:
tab1(origin) tab2(destination) c tab3(days#)
antwerp chicago 5
antwerp new york 10
antwerp LA 12
lecce chicago 4
lecce LA 12
Is there any way in the first tab to have a drop down and select two matching destinations to generate the result in the 3 column?
for example select lecce and LA in the dropdowns to have it generate the result 12 days in another cell in the first tab?
I generated the drop downs using the data validation tool in DATA and created the two types in the name manager naming them "Origin" and "Destination"
