Sorry I might not have been clear enough.
The data is not meant to be symmetrical, it could come up in any order, all "dogs"except for one "no".
What I want to retrieve is a value if all the data to the right of C up to L is of the same content as cells B and C for the corresponding row.
Ie. row 3: cells D:L contain only dog and no so Id like it to return a value of "x"
Whilst row 4 cells D:L contain cat no and dog so I'd like it to return a value of "y"
IF row 4 cells D:L contained only cat and no then I'd to have a value of "x" returned.
Is that clearer?
Bookmarks