HI I would like to have some help with this problem.
In sheet "Final Match" i need to compare the names in column C
with names in sheet "New Cars input" column B
It need to find the matching payments in column M Sheet "New Cars input"
and display them in new column J Sheet "Final Match".
So i guess its a kind of vlookup. But i need a macro for this.
In Below testsheet you can see how it have to be.
I have also this below code, which i think is a jindon code, which maybe can be changed so it works here.
I have tried but cant make that work
But please have a look.
Sincerely
Abjac
The code which maybe can be changed.
Bookmarks