Excel formula, which is very easy to use in wps, was automatically upgraded today, so the formula can't be used. It is said that there is an error in the formula entered, so you should enter single quotation marks. 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", "Bahen", "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.