Compare two cells for same keyword

[elsmith9035768]

If Column F has "yes" in a cell and any cells in that row (would be row 10 in this example) also has a "yes", I need a "1" inserted in that column on row 8.

 

[deciog]

elsmith9035768

Check if this is correct for you

Decio

 

[elsmith9035768]

deciog, for some reason the formula is returning #VALUE! instead of 1. Also, I didn't state this in the question, but if the return is not 1, I need the formula to return 0 or have the cell stay blank. Thanks for your help.

 

[r2c2]

deciog, for some reason the formula is returning #VALUE! instead of 1. Also, I didn't state this in the question, but if the return is not 1, I need the formula to return 0 or have the cell stay blank. Thanks for your help.

Try this instead.

Paste =MAX(($F$9:$F$12="yes")*(G$9:G$12="yes")) in G8. Press Ctrl+Shift+Enter. Now copy the formula across thru column J.