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
Bookmarks