Forum Discussion
If formula help
I have a spreadsheet that is going to be rather lengthy. I need a formula that will: 1. Determine the value of all the cells in G (either "Yes" or "No" Value) IF the cells in column C equal the c...
Perhaps in G2:
=IF(ISNUMBER(XMATCH(C2, $M$2:$M$13)), "No", IF(ISNUMBER(XMATCH(C2, $M$14:$M$23)), "Yes", ""))
Fill down.