Hi,
I have a list of destinations and packages on one tab and another tab with the destinations, package and a code.
I am trying to use the data in the 1st tab to search the 2nd tab to fill in the 3rd tab with the code.
E.G in the 1st tab I have:
Destination Package
Australia 3G
in the 2nd tab:
Destination Package Code
Australia 3G DHI_AU_DP_3GSpeed
And I want the formula in the 3rd tab to return the code based of the selection in the first tab.
I have tried Vlookup and Match but I can't quite figure out what I need or even if they are the right functions to use.
Attached an example sheet.
Any help appreciated thanks!
Bookmarks