Change a Row Value if all records match with another row in another sheet

[caabdul]

Sheet1 and sheet2 have 3 columns each

Please Login or Register  to view this content.

I can only think of a lot of loops to do this task but it will be very lengthy and macro will also take much time.

What is the quickest way to do it?

[Mumps1]

Try:

Please Login or Register  to view this content.