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