This formula has more than 7 levels of IF nesting, and this formula is only supported by documents in. Xlsx format. (.et and. Xls format does not support nesting above 7 levels. )

The new version of WPS table can be found in. Xlsx format.

You can also use the following formula:

=IFERROR(LOOKUP( 1, 0/find) ({"sogou", "Xiongbu", "Shoushen", "Yanmeibu", "Tournament", "Xiaba", "Tuomao", "Chuzhou", "Ba Hate", "Jiguang" and ". "Micro plastic surgery", "plastic surgery", "red blood", "freckle", "Tai Chi", "takeaway", "privacy", "wide face", "mouth", "lips", "search"}), "")

The items in the braces are one-to-one correspondence, separated by English commas.