+ Reply to Thread
Results 1 to 2 of 2

Matching Data from multiple columns

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    Eau Claire, WI
    MS-Off Ver
    2010
    Posts
    65

    Matching Data from multiple columns

    All -

    I have 3 columns of data all with varying data set lengths. What I am trying to do is take columns B and C and make sure I find a match to it in column A. If both B and C match I want to return the values in a new column. Rows 2-5 would be an example of what I want the final data set to look like. The remaining rows is what the raw data currently looks like (over 1000 rows). The three columns do not have the same number of rows of data as shown.

    I tried using match index and it does not seem to be working as I would like. If a match is found I want the matches on the same row in new columns. Anything that does not match both columns, I would like a blank returned. Attached is a sample workbook.
    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: Matching Data from multiple columns

    in D2
    =LOOKUP(NOT(ISNA(VLOOKUP(B2,A$2:A$30,1,0)))+NOT(ISNA(VLOOKUP(C2,A$2:A$30,1,0)))*2,{0,1,2,3},{"None","B","C","Both"})&" match"
    and now

    Output indicates whether none, column B, column C or Both match
    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.

+ 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. Replies: 0
    Last Post: 10-16-2013, 12:42 PM
  2. Replies: 5
    Last Post: 10-01-2013, 02:34 PM
  3. [SOLVED] Need a macro code for matching a data and copying multiple columns
    By faizaan316 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2013, 01:40 PM
  4. Extracting data from multiple columns with multi value matching
    By Antagonizer82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2012, 02:59 PM
  5. Matching data form multiple columns
    By Revverend in forum Excel General
    Replies: 3
    Last Post: 08-04-2011, 07:34 AM
  6. Matching Data with multiple columns
    By Jimboted in forum Excel General
    Replies: 9
    Last Post: 04-01-2011, 01:50 PM
  7. Matching row data from multiple columns
    By cmw52 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2009, 12:02 PM
  8. [SOLVED] Matching data in multiple columns
    By BuddyB in forum Excel General
    Replies: 2
    Last Post: 02-27-2005, 05:06 PM

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