Forum Discussion

YvetteGarza's avatar
YvetteGarza
Copper Contributor
Jul 24, 2020

Formula help needed; IF or IFS?

AF2, AF6, AF10 and AF16 have several zip codes separated by a comma. I know V2 is listed in AF16 but I keep getting False as the answer. How can I correct this formula? Using 365.   =IF(V2=AF2,"Coa...
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 25, 2020

YvetteGarza 

Perhaps like this

with

=IF(V2="","zip is not defined",
 IF(COUNTIF($AE$2,"*"&V2&"*"),"Coastal",
 IF(COUNTIF($AE$6,"*"&V2&"*"),"Zone A",
 IF(COUNTIF($AE$10,"*"&V2&"*"),"Zone B",
 IF(COUNTIF($AE$16,"*"&V2&"*"),"Zone C",
 "wrong zip"
)))))
YvetteGarza's avatar
YvetteGarza
Copper Contributor
Jul 28, 2020

SergeiBaklan 

YAYYYY! Success, I changed the "wrong zip" to "Not Listed" but other than that, your formula worked. Now I need to learn/understand the reasoning behind this so I can retain the thought process.

Thank you so much!!

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 28, 2020

    YvetteGarza , you are welcome. Not sure how you reproduced the formula, better to take not from post but from the file attached to it.

Resources