If within an If then another then another...(with a twist)

Hello, I've been trying to figure out the syntax for my formula but I can't. I need your help. Okay, here is what I am trying to do: IF a value is find in a given range do another if(match...

excel

Formulas and Functions

SergeiBaklan

Nov 27, 2021

kheldar

As variant

=IF( ISNA( MATCH( Names!A2, S17:S20, 0 ) ),
     IF( ISNA( MATCH( Names!A3, S17:S20, 0 ) ),
         IF( ISNA( MATCH( Names!A4, S17:S20, 0 ) ),
             "not found",
              "sth2"
          ),
          "sth1"
      ),
     "sth" )

nested if names.xlsx10 KB

Forum Discussion

If within an If then another then another...(with a twist)

Resources