I need to create a formula that will check for a word in a cell and return a value or if the word does not exist then check for another word.

Eg. Check Cell A1 contains the word "red" then print "RED" if A1 does not contain the word "red" then check if A1 contains the word "blue" and print "BLUE". If A1 does not contain the word "red" or "blue" then leave empty.

Something like: =IF(A1 Contains "red","RED",If A1 Contains "blue","BLUE,"")

  • with IF()

    =IF(A1="red",  "RED",
     IF(A1="blue", "BLUE", ))

  • with IFS()

    =IFERROR(IFS(A1="red",  "RED",
                 A1="blue", "BLUE"), )

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.