vendredi 25 septembre 2015

IF statement which finds multiple words

I want to create an IF statement which finds more than one value I have tried adding another IF but this doesn't seem to work and i am not sure why.

Below is the formula i have so far.

   =IF(IFERROR(SEARCH(Sheet2!$A$1, I2), 0), "found", "none")

This searches in Sheet 2 what is in Column A row 1 if this is found in Column I2 of the Sheet 1.

I want the IF statement to also find what is in Sheet2!$A$2, Sheet2!$A$3 and Sheet2!$A$4

Can anyone help? :)

Aucun commentaire:

Enregistrer un commentaire