Please help me with the problem below:
I am using IF(SEARCH('Fashion',A1)1,0) to search for word Fashion in Column A. It gives 1 when it finds word fashion but gives error #VALUE! when gets words such as 'Lifestyle' and 'Photography'.
Basically containing letters of word 'Fashion'.
Aucun commentaire:
Enregistrer un commentaire