Conditional if cell has this, then display this, else display this – Google Sheets

This is a formula written for Google Sheets.

It looks for text matching one of three conditions and otherwise will display ‘Not Detected’.

=IF(ISTEXT(REGEXEXTRACT(E2,"Peter")),"Pete", IF(ISTEXT(REGEXEXTRACT(E2,"KWP")),"KWP!", IF(ISTEXT(REGEXEXTRACT(E2,"Frank")),"Frankie", "Not Detected") ) )

Revisions

Tags: , ,

No comments yet.

Leave a Reply