title: Ideal Concept for Excel Lookup - Using High and Low Values to define ZIpCode Ranges which pertain to Territories
body: <p>I have two tabs, one is "sales detail" which contains a field named "sales zipcode". The "sales territory" tab has a range of zipcodes and the corresponding "Sales Territory ID" </p>
  
  <pre><code>Zipcode Low        Zipcode High       Sales Territory ID
  
  10000              19999                    15
  
  20000              24999                    20
  
  25000              33999                    22
  </code></pre>
  
  <p>ETC ETC </p>
  
  <p>How can I write a formula for the Sales Territory ID based on the Zipcode?</p>
  
  <p>For instance</p>
  
  <pre><code>Zipcode  Sales Territory ID
  
  02348        =???       
  
  23485
  
  23433
  </code></pre>
  
  <p>Thank you for your help.</p>