=SUMPRODUCT(--ISNUMBER(SEARCH({"red","blue","green","black"},EN2)))>0
Hello, Im using SUMPRODUCT for the first time, to search for cells containing words.
Is there a way to adjust this formula, so that the actual word that is found eg. 'blue' is the result, instead of TRUE
and also for the result cell to be blank if there is is a FALSE result?
Thanks in advance
Hello, Im using SUMPRODUCT for the first time, to search for cells containing words.
Is there a way to adjust this formula, so that the actual word that is found eg. 'blue' is the result, instead of TRUE
and also for the result cell to be blank if there is is a FALSE result?
Thanks in advance