Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Check if entered value is in a list of values

jasons17295687
Level 1
Level 1

I need to determine rate billed based on zip code and a couple other factors.  I'm trying to determine the best route.  Each group of zip codes has around 100 possibilities.  For example 97003 in Group A would bill at $4 and 97002 in Group B would be $5. 

I really just need help with returning a value for the Groups, the other validations I have figured out but am running into difficulty with the script for that many options to check.  Hope that all makes some sense.

For Example

Group A -

97003,97004, 97005 ....

Group B

97002,97011,97016 ...

Any suggestions would be greatly appreciated.

0 Replies