Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Apr 22, 2020 06:22 AM
Hello,
I’m writing a formula to tell me the DMA region of a client based on a list of zip codes. Here’s my formula so far:
IF({Zip Code}=‘34471’,‘Tampa’,IF({Zip Code}=‘32703’,‘Orlando’,‘Other’))
I just need to know how to turn ‘34471’ and ‘32703’ into a list of zip codes (I already have the list), where ‘Tampa’ or ‘Orlando’ could be triggered for any match in that list.
Thanks!
Apr 22, 2020 07:15 AM
Hi @Lance_Devore - unfortunately, there isn’t a way in a formula to do this (pseudo code):
IF({Zip Code} is one of [12345, 12346, 12347], 'Tampa', etc)
Two ways you could get around this:
(You can copy and paste multiple cells at a time).
JB