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