Post Code to determine the Clinic
I hope someone can help -I'm new at all this. I need to write a script that will determine which clinic to refer a patient according to their post code. Unfortunately it is not in any sensible order eg
4000 - 4347 -> Clinic A
4341 - 4343 -> Clnic B
4410 -> Clnica A
4499 - 4601 -> Clinic C
I can't seem to get around scripting a Post Code between 4000 and 4347 and don't know how to do it. I'm sure that this is basic but it's got me.