mardi 26 novembre 2019

Looking for ANY of the list items in a defined string

we have the following situation. We have 1 cell to show the result of a determination in. We have 1 cell to check-in. And 1 list of items to check against.

Said otherwise: The resulting cell should loop through all the items in LIST OF FRUITS. If ANY of the fruits is found in the string in CELL TO CHECK then print "Found" - or if easier print the list item that was found.

Question: Is this possible and if so then how?

TEST A (Found)
RESULT CELL          CELL TO CHECK
Found!                     mangoes

TEST A (Not found)
RESULT CELL          CELL TO CHECK
-                    Pineapple


LIST OF FRUITS
Apples
Pears
Bananas
Mangoes

Aucun commentaire:

Enregistrer un commentaire