Forum Discussion
YvetteGarza
Jul 24, 2020Copper Contributor
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...
YvetteGarza
Jul 24, 2020Copper Contributor
I have zip codes like this in those cells.
| 77414,77422,77465,77534,77541,77550,77551,77554,77563,77577,77623 |
YvetteGarza
Jul 28, 2020Copper Contributor
Nope didn't work. Thanks so much for trying though.