I am trying to write an auto-expanding formula that tests if a value exists Stakeholders/Communities
in column D
on sheet Elements
if it does write Yes in not write No
I have tried various thing, like
=ArrayFormula(IF(INDIRECT(Elements!D2:D="Stakeholders/Communities"),"Yes","No"))
But not getting it
Aucun commentaire:
Enregistrer un commentaire