Hello,

In column A i have employee ID numbers.
In column B, I have an event list.

I would like column C to detect when...
...the word "Transfer" is mentioned in column B...
...whilst beside it in column A the number is less than 20...and...
...the next 2 numbers down are also less than 20, BUT at least one of those numbers are different to the initial number.

So for example:
4 Transfer [POSITIVE RESULT]
4 Apple
7 Banana


BUT
4 Transfer
4 Apple
4 Banana
Will have No Result

I would like the word used to be "Positive Result" please.

Thank you