+ Reply to Thread
Results 1 to 9 of 9

Using multiple values to find another value

Hybrid View

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Using multiple values to find another value

    I will repeat my question in different words.

    On the Codes sheet there are two different records for Afghanistan on rows 2 and 3. When I enter Afghanistan in cell B2 on the Order List, how do I know which one of these two records to use? How do I know whether to select 3G or 4G and put it in cell E2?

    I can see a way that if I enter Afghanistan in Cell B2 and I enter 3G in Cell E2 then I can look up DHI_AF_DP_3GSpeed and place it in cell F2.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Registered User
    Join Date
    12-07-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    9

    Re: Using multiple values to find another value

    Right I see. Sorry!

    "I can see a way that if I enter Afghanistan in Cell B2 and I enter 3G in Cell E2 then I can look up DHI_AF_DP_3GSpeed and place it in cell F2."

    That would be perfect for what I need to do thanks.

+ Reply to Thread

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