SOLVED

If Duplicate, Continue?

%3CLINGO-SUB%20id%3D%22lingo-sub-3241662%22%20slang%3D%22en-US%22%3EIf%20Duplicate%2C%20Continue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241662%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%20-%20I'm%20trying%20to%20create%20a%20statement%20which%20references%20something%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20A2%3DB2%20then%20continue%2C%20If%20A2%3DC2%20then%20continue%2C%20If%20A2%3DD2%20then%20continue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20want%20it%20to%20return%20the%20contents%20of%20a%20cell%2C%20which%20doesn't%20equal%20A2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20Nested%20IF%20function%2C%20but%20this%20doesn't%20seem%20to%20be%20the%20answer!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20support%20would%20be%20appreciated%2C%20thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3241662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3241872%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Duplicate%2C%20Continue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1322017%22%20target%3D%22_blank%22%3E%40E_D123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DINDEX(%24B%242%3A%24J%242%2C%2CMATCH(1%2CN(%24B%242%3A%24J%242%26lt%3B%26gt%3BA2)%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20with%20this%20formula%20as%20shown%20in%20the%20attached%20file.%20Enter%20the%20formula%20with%20ctrl%2Bshift%2Benter%20if%20you%20don't%20work%20with%20Office365%20or%202021.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 Replies
best response confirmed by E_D123 (Occasional Contributor)
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.

This works, thank you!