Forum Discussion
looking to complete an if/countif/and statement
The formula is currently at =IF(AND(COUNTIF($P$2:$P$210,$S$214),COUNTIF($N$2:$N$210,S215)), $C2, "") The goal is to check column P for cells containing a specific value AND column N for a specifi...
- in excel 365 try:
=XLOOKUP($S$214&S215, $P$2:$P$210&$N$2:$N$210, $C$2:$C$210, "")
in excel 365 try:
=XLOOKUP($S$214&S215, $P$2:$P$210&$N$2:$N$210, $C$2:$C$210, "")
=XLOOKUP($S$214&S215, $P$2:$P$210&$N$2:$N$210, $C$2:$C$210, "")
