samedi 1 février 2020

ArrayFormula with IF Google Sheets

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