dimanche 29 mai 2016

Search in excel

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