If formula help

Question

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!

hansvogelaar · Answer

ChrystinaH&nbsp;
Perhaps in G2:
=IF(ISNUMBER(XMATCH(C2, $M$2:$M$13)), "No", IF(ISNUMBER(XMATCH(C2, $M$14:$M$23)), "Yes", ""))
Fill down.

Forum Discussion