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!
=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!