Compare values from tables located in different sheet + adding comment

[Rezo]

Hello all,


I’m facing a difficult time trying to find a macro that would compare the values in 2 different tables located in different sheets and returns a predefined comment based on the values in the specific sheets.
Tried IF-Vlookup combination but don’t know how to set multiple criteria and also predefined comments. Trying to write all this in visual basic to create a macro but having a hard time building up the logic combining functions. Quite new into this..
I attached an excel file with a small example of what I’m aiming for and the problems that I’m facing when trying to create the code.
Hope that someone has some spare time to look into this and give me an example or an advice on how to do it. I would greatly appreciate any help!


Best regards,
R