I have a match function that selects the code and returns the position
=MATCH("G222",C1:C70,0)
How to change the formula to say
if match found then in cell S20= completed or if not found then S20=incomplete
when a match is not found it gives #NA how to work around that.
appreciate all your help
=MATCH("G222",C1:C70,0)
How to change the formula to say
if match found then in cell S20= completed or if not found then S20=incomplete
when a match is not found it gives #NA how to work around that.
appreciate all your help