CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas
xyz333
xyz333

Reputation: 768

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

Upvotes: 1

Views: 231

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(INDIRECT("Elements!D2:D")="Stakeholders/Communities", "Yes", "No"))

Upvotes: 2

Related Questions