I need to insert text if the preceding three cells match.
1st row = A B C D
2nd row = A B C
Result = A B C D
If no match result would be = A B C XXX
If the first three cells in the second row match the first row, add the fourth cell. If it doesn't match then it should insert a placeholder text (like XXX).
Does this make sense?
Attached is a sample file.