=if(isna(match(g11,o_p,0)),"",if(isna(match(g19,pws_log_ware,0)),w867,""))

[MARKEGANDERSON]

Hello All-

The below formula gives me a check mark(W867), if cell G11 matches "O_P". I am having issues with the second part of the formula - I wanted a check mark also if G19 matches "PWS_LOG_WARE", if not "".
=IF(ISNA(MATCH(G11,O_P,0)),"",IF(ISNA(MATCH(G19,PWS_LOG_WARE,0)),W867,""))

Please help

 

[JoeMo]

Asssuming O_P and PWS_LOG_WARE are named ranges, try:

=IF(ISNUMBER(MATCH(G11,O_P,0)),W867,IF(ISNUMBER(MATCH(G19,PWS_LOG_WARE,0)),W867,""))

 

[MARKEGANDERSON]

Thank you sir! worked like a charm!

 

[JoeMo]

Thank you sir! worked like a charm!

You are welcome - thanks for the reply.