If Duplicate, Continue?

[E_D123]

Hi there - I'm trying to create a statement which references something like:

If A2=B2 then continue, If A2=C2 then continue, If A2=D2 then continue.

Basically I want it to return the contents of a cell, which doesn't equal A2.

I've tried Nested IF function, but this doesn't seem to be the answer!

Any support would be appreciated, thank you. 

[#2 · Accepted solution]

@E_D123 

=INDEX($B$2:$J$2,,MATCH(1,N($B$2:$J$2<>A2),0))

Maybe with this formula as shown in the attached file. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

[#3]

This works, thank you!