Forum Discussion
Excel
I need to lookup values in two columns and have a third column show the result but I cannot find the correct formula. e.g if column a = yes and column b = yes then = Yes, however if column a is eithe...
Hi,
=COUNTIFS(A1:B1,"Yes")=2
=UND(A1="yes";B1="Yes")
For "Yes" and "No" just wrap an IF() around it.