Q5:Q1494 contain yes and no values and are custom formatted where a 1 returns “yes” and 0 returns “no” 

The following formula is inserted into cell Q1495 and filled down into many cells

=IF(ISERROR(VLOOKUP(G1528,$G$5:$Q$1494,11,0)),””,IF(VLOOKUP(G1528,$G$5:$Q$1494,11,0)=0,””,VLOOKUP(G1528,$G$5:$Q$1494,11,0)))

The problem with this formula only 1 “yes” is returned, 0 “no” are ignored

What needs changed in the formula so that 0 “no” are returned also?

Thank you if you can help!

​ Q5:Q1494 contain yes and no values and are custom formatted where a 1 returns “yes” and 0 returns “no”  The following formula is inserted into cell Q1495 and filled down into many cells =IF(ISERROR(VLOOKUP(G1528,$G$5:$Q$1494,11,0)),””,IF(VLOOKUP(G1528,$G$5:$Q$1494,11,0)=0,””,VLOOKUP(G1528,$G$5:$Q$1494,11,0))) The problem with this formula only 1 “yes” is returned, 0 “no” are ignored What needs changed in the formula so that 0 “no” are returned also? Thank you if you can help!  Read More

​