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 cells in M2-M13 then the corresponding cell in G should say "No"
If the cells in column C equal the options in cells M14-M23 then the corresponding cell in G should say "Yes"
I hope that is a good way to articulate my needs. Gah!
TIA!
1 Reply
Perhaps in G2:
=IF(ISNUMBER(XMATCH(C2, $M$2:$M$13)), "No", IF(ISNUMBER(XMATCH(C2, $M$14:$M$23)), "Yes", ""))
Fill down.
