+ Reply to Thread
Results 1 to 1 of 1

Compare multiple columns from 2 spreadsheets, highlight differences & return values

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    13

    Compare multiple columns from 2 spreadsheets, highlight differences & return values

    Hi all,

    I have a project for which a colleague and I are doing research in 2 different databases and inputting information into a spreadsheet. Our base spreadsheet was the same, but now the number of companies is slightly different because my colleague deleted rows describing certain things (medical devices). The goals of this project will come in two parts: First, I am seeking to compare the Company Name column and Asset Name column from Sample1 against the same columns from Sample 2, and to highlight any rows that are not the same between those two. It's very important that [I]both[I] the Company Name and Asset Name columns match because there are thousands of both, and there is a row per asset. Thus, if PharmaCompany1 has five assets, there are 5 rows with that company's name, each of which has info on a different asset belonging to that company. I know from using a COUNT that there are 5 differences between our sheets, meaning that I have 5 more companies in my list than my colleague does. I need to know which 5 entries those are so I can delete those rows from my spreadsheet.

    Secondly, I need to merge the data from her spreadsheet into mine. I played with VLOOKUP, but could not find a way to make it compare multiple columns and return multiple values. In the attached worksheet, this is what I am seeking:
    -From Her Spreadsheet, the values in Column J need to be copied over to my spreadsheet's Column D, and the values in her Column K need to be copied over to my Column E. But this is only if the Company Names in Columns A and G match AND if the Asset Names in Columns B and H match (so that info is pulled on the same asset).

    I would appreciate any directions or suggestions!

    Best,
    Willie
    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. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  2. Replies: 9
    Last Post: 04-18-2013, 03:54 PM
  3. [SOLVED] Compare columns in different worksheets nad highlight differences
    By intercooler in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-13-2012, 01:05 PM
  4. Replies: 5
    Last Post: 01-06-2012, 04:15 AM
  5. Compare Values in Multiple Columns and return a result
    By edbhome in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-18-2009, 09:37 AM

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