+ Reply to Thread
Results 1 to 4 of 4

Vlook up for multiple columns?

  1. #1
    Registered User
    Join Date
    05-01-2017
    Location
    US US
    MS-Off Ver
    2013
    Posts
    6

    Vlook up for multiple columns?

    Hello everyone,

    I was hoping to get more of your expert help with excel. I've been trying for two days but can't seem to figure out what I am doing wrong or if I am even going in the right direction, I'm hopeful someone here can help me please.

    I am trying to get excel to look at the values in each row of sheet1 and see if they are an exact match to any row in sheet two. If so I want excel to take the Value in the value column of sheet2 and place it in the Column1 of sheet1. For example if row 1 sheet1 has N Copy Empty No and row 5 in sheet2 has the same values in the same columns then I want it to return the value in the Value column of sheet2 to column1 of sheet1

    I've tried everything I can think of but can't get it to work. I have attached a sample workbook so you get a better idea of what I'm trying to do


    Any help is greatly appreciated.

    Have a great day
    Attached Files Attached Files

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

    Re: Vlook up for multiple columns?

    in Sheet1!G2
    =INDEX(Sheet2!F$2:F$30,MATCH(A2,IF((B2=Sheet2!B$2:B$30)*(C2=Sheet2!C$2:C$30)*(D2=Sheet2!D$2:D$30)*(E2=Sheet2!E$2:E$30),A$2:A$30),0),1)
    Array formula, use Ctrl-Shift-Enter


    UPDATE: Before you say this doesn't work, none of your example data matches.

    UPDATE2: Sheet1 Column D has a space after each entry, the column that's supposed to match (Sheet2 Column D) does not. Therefore they will not match. You'll need to fix that.
    Last edited by Special-K; 05-02-2017 at 11:37 AM.
    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 Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Vlook up for multiple columns?

    You could try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  4. #4
    Registered User
    Join Date
    03-31-2014
    Location
    dubai
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Vlook up for multiple columns?

    Check the attachment.

    I assumed there will be no duplicates, however in case there will be duplication use column J instead of column I in match function.

    As mentioned by Special-K none of your data matches so I inserted 2 rows on both sheets.
    Attached Files Attached Files

+ 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] Multiple Vlook up values
    By i82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-16-2016, 06:37 AM
  2. Vlook up with multiple Criteria
    By crescendo in forum Excel General
    Replies: 7
    Last Post: 02-27-2015, 02:47 PM
  3. Vlook up compare two columns and more!
    By humdiddydum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2014, 12:34 PM
  4. Help with Vlook up to multiple Tabs
    By Erico248 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2014, 11:15 AM
  5. Vlook up not working on multiple columns
    By benji8798 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2013, 10:18 PM
  6. multiple vlook ups help!!!!
    By floricita in forum Excel General
    Replies: 8
    Last Post: 09-13-2012, 07:35 AM
  7. Vlook up on 2 columns - is this possible?
    By Lorna B in forum Excel General
    Replies: 15
    Last Post: 10-20-2009, 12:33 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