Return "Yes" or "No" if column contains specific text

[catiexcel]

Hey! I've this spreadsheet where columns G-N are roles, and the each role is responsible for certain events and errors. Right now I'm focusing on column N - Location. This one should be the easiest, as the only errors Location is responsible for are "Coordinates". I've tried the formula:

=IFERROR(IF(MATCH($Z$9,D:D,0),"yes",),"no")

but it returns Yes for everything and I don't understand why?

FYI, $Z$9 is referring to a the word "Coordinates" in a list of the error types.

Any help appreciated!

 

[Joe4]

=IFERROR(IF(MATCH($Z$9,D:D,0),"yes",),"no")

but it returns Yes for everything and I don't understand why?

FYI, $Z$9 is referring to a the word "Coordinates" in a list of the error types.

Because the word "Coordinates" actually does appear in column D (multiple times, in fact).
Note that you are searching ALL of column D, not just a single row.

 

[Fluff]

Maybe

=if(d2="Coordinates","Yes","No")

 

[catiexcel]

Thanks guys, they both worked, I knew I was doing something wrong!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[catiexcel]

I might ask ye about the next bit two, in relation to columns G - M. I need to return "Yes" using three criteria: Team, Event, and Error. It is looking for whether each criteria match in three other arrays. Is this possible?

This is the Issue Logs tab

This is the Admin tab where two of the arrays are that the Events and Errors should match to.

 

[Fluff]

As this is a significantly different question, it needs a new thread. Thanks