ArrayFormula with IF Google Sheets

Question

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

player0 · Accepted Answer · 2020-02-01 16:36:23Z

2

try:

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

answered Feb 1, 2020 at 16:36

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ArrayFormula with IF Google Sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related