+ Reply to Thread
Results 1 to 4 of 4

Vlookup match two variables from two tables

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Microsoft 2016
    Posts
    74

    Talking Vlookup match two variables from two tables

    Hi everyone!

    Can someone help me with the attached sample. Assume the tables would be very large and so I'm looking to find a formula that would look for two (or perhaps 3) variables to ensure that I am returning the correct values.

    In the samples attached, I'm trying to look up values in table B but make sure the actual value corresponds with the data from table A.

    Table B: Discount of $17 from Store number 1 in Unit Name 1108 on specific Date 1/4/2019.

    The output table highlighted in yellow is where I would like the data to go. I've create a blank table for this exercise below the Output Table.

    Thank you very much for your help in this


    Note: I'm able to use vlookup to capture one variable but not sure how I can match two variables from the two tables.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Vlookup match two variables from two tables

    Your output is incorrect, H23 is blank. For row 23 the output should come from F14 and G5.


    in G23
    =INDEX(G$3:G$8,MATCH(F23,IF(D23=D$3:D$8,F$3:F$8),0),1)

    in I23
    =INDEX(G$12:G$17,MATCH(F23,IF(D23=E$12:E$17,D$12:D$17),0),1)

    NOTE: These are both ARRAY formulas

    Array formula, use Ctrl-Shift-Enter
    Last edited by Special-K; 01-07-2019 at 01:10 PM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Vlookup match two variables from two tables

    In H30 then copied across I35
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Registered User
    Join Date
    08-18-2017
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Microsoft 2016
    Posts
    74

    Re: Vlookup match two variables from two tables

    Thank you for the quick help - I was able to make it work. woot!

+ 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. VLOOKUP/INDEX/MATCH Formula to look up value from two tables.
    By acsishere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2017, 04:03 AM
  2. [SOLVED] Extracting information from multiple tables (Vlookup, Index match, indirect??)
    By vesper007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2016, 02:36 AM
  3. vlookup, indirect and match from multiple tables
    By rudrugis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2013, 06:21 PM
  4. [SOLVED] Vlookup or index match with 2 or more variables
    By jasonleewkd in forum Excel General
    Replies: 7
    Last Post: 12-14-2012, 04:51 AM
  5. Repeating Variables-VLOOKUP or INDEX/MATCH?
    By jbritt609 in forum Excel General
    Replies: 4
    Last Post: 06-10-2009, 01:16 PM
  6. Need data cross-referenced in multiple tables: VLOOKUP vs. Match vs. Index
    By James McMurray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2008, 02:53 PM
  7. Please Help! vlookup & match with multiple variables
    By ivygirl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2006, 05:50 AM

Tags for this Thread

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