VBA code explanation needed - Sometimes outputs wrong data

[Biinge]

Hi all

I have used the below code for a while, but it sometimes outputs values in a cell when its not supposed to.
i got help creating this code in this forum a while ago

Please Login or Register  to view this content.

What this code does is mathing row A and B in sheet "ordre" with row A and B in sheets "kommentarbackup" and
copies row C from "kommentarbackup" to row L "ordre" in column where both matches.

I think that my problem is when i have a row A and B that doesnt match - i think in these cases the formula copies the corresponding row anyway - (example : now match row A and B "ordre" row 265 : copies row C "kommentarbackup" row 265 to row L "ordre" row 265. Not sure though

ill paste the link to my original post for further explanation :
http://www.excelforum.com/excel-prog...-in-range.html

[OnErrorGoto0]

Your code passes 0 to the INDEX function when a value is not matched, which is the equivalent of getting the whole column back. I would use something like

Please Login or Register  to view this content.

[Biinge]

Thanks that code works perfect!