Compare 2 sheets (not resolved)

[Sniper]

I had a previous post about this but at first I thought the help given would work but after 8 hours I now see it's not the way to go. I have 2 sheets that I need to compare withe each other, the biggest problem is that there are a lot of duplicates that shouldn't be removed so the vlookup function doesn't work. I did attach a new example.

Thanks

[shg]

I've unmarked your prior thread as solved. Please resume there for continuity.