I am trying to do something that I think should be very simple but for the life of me I cannot work it out and am getting increasingly frustrated.

I have numbers in the columns and want to say if columns 1 and 3 match and columns 2 and 4 match, then the fifth column should have YES, but if columns 1 and 3 match and column 4 is greater than or less than column 2, then the answer should be MAYBE. Hopefully this makes sense! Can anyone help please?

Many thanks