Forum Discussion

kheldar's avatar
kheldar
Iron Contributor
Nov 27, 2021
Solved

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's avatar
    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" )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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" )
kheldar's avatar
kheldar
Iron Contributor
Dec 06, 2021
Sorry for not seeing your response, I thought I had mail notifications on.

Resources