Thread: replace certain values

This will be difficult to explain... I'll try my best:
I was creating a database, only to discover that the database was already partially completed by one of my coworkers. I decided to integrate the parts his database has with those that I have. So, here we go.
I have a spreadsheet that has a structure something like this

Name   i1   m1   m2   m3   m4   m5   m6   i2   i3   i4   i5

i stands for info, and m stands for missing. These are called missing because these data are not in my coworker's database. However, for any given row, I can be missing any of the data (for example, i1 and i3). His database always has all of the "i" parts for a given name. Names can be repeated, and perhaps most annoying is that his order of i2, i3, i4, and i5 is not always the same order as mine.
I would like to copy all of the rows that I do not have into my database. And if I have a very incomplete entry (say, only the name and i5), then replace my row with the row of my coworker's that matches in name and the available info.
So, I was hoping for a macro that takes his spreadsheet and adds it to mine accordingly. Thanks. I know it's a lot of words, but I'll be happy to answer any questions.

Hi,

maybe the solution does not require a macro. Maybe it can be solved with Vlookup and/or Index/Match. To help you further, it would be good to see a data sample. Why don't you prepare a workbook with three tabs

- your data
- your co-worker's data
- your expected outcome

A handful of rows per sheet should suffice, but make sure you include enough data to illustrate what you want to achieve and specify the logic that leads to the result.

To upload a workbook, click "Go Advanced" below and then the paperclip icon to attach a file

cheers

i assume that the Missing data is blank?