Results 1 to 9 of 9

Using multiple values to find another value

Threaded View

Tortoise90 Using multiple values to find... 01-30-2019, 01:23 PM
BadlySpelledBuoy Re: Using multiple values to... 01-30-2019, 03:50 PM
dflak Re: Using multiple values to... 01-30-2019, 04:33 PM
Tortoise90 Re: Using multiple values to... 01-31-2019, 06:28 AM
dflak Re: Using multiple values to... 01-31-2019, 01:03 PM
Tortoise90 Re: Using multiple values to... 01-31-2019, 01:17 PM
dflak Re: Using multiple values to... 01-31-2019, 01:53 PM
Tortoise90 Re: Using multiple values to... 01-31-2019, 02:00 PM
dflak Re: Using multiple values to... 01-31-2019, 02:56 PM
  1. #1
    Registered User
    Join Date
    12-07-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    9

    Using multiple values to find another value

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Find and Replace Multiple Values Across Multiple Sheets
    By MattyD123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2018, 10:44 PM
  2. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  3. Find multiple values in multiple ranges and produce results in a list
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 02:11 AM
  4. [SOLVED] Faster way to find and replace multiple values with corresponding values
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 06:50 PM
  5. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  6. Find and compute multiple values from multiple tables
    By canada123 in forum Excel General
    Replies: 2
    Last Post: 07-18-2011, 09:00 PM
  7. Find and Replace values from multiple lookup values
    By Gregula82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2007, 03:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1