Matching 2 columns and output result in third column

[tubells]

hi,

I have two columns ( B & G) with title called 'device name'. Column B will have hundreds of entries but Column G will have just a limited number i.e. Column G will just be a subset of B. The text in both will be the same.

What I want to do is:

If
Any cell in columns C, D or E is in red
Then
look at the corresponding cell in column B and see if there is a match to any cell in column G
If
There is a match
Then
Output 'pay' in column F in the corresponding row
Else
Output 'no pay' in column F in the corresponding row
Else
Do nothing
End

I hope this is clear.
thanks,


now I just have to figure out how to attach my sample file.