• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

match function help with forumla required

vpxlquest

Member
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
 
We can put the MATCH function in an error trap, specifically the ISNA function:

=IF(ISNA(MATCH("G222",C1:C70,0)),"incomplete","completed")
 
Back
Top