title: Excel - Categorize lines of data based on 3 variables
body: <p>I have the following problem:
  <a href="https://i.stack.imgur.com/OqOHs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OqOHs.png" alt="Sample"></a></p>
  
  <p>I have two sheets in the excel file that are included in this problem.</p>
  
  <p>The first sheet contains the constraints for each group and is the first part of the picture.</p>
  
  <p>The group “Correct 1” is a group where following restrictions are met: </p>
  
  <p>“value 1” is between 0-1000</p>
  
  <p>“value 2” is between 0-2000</p>
  
  <p>“value 3” is between 0-500</p>
  
  <p>_</p>
  
  <p>The second sheet contains the data I want to label with the correct group based on the three values (1, 2 &amp; 3).</p>
  
  <p>For example: </p>
  
  <p>The row labeled “info1” has three values connected to it.</p>
  
  <p>value 1 = 321  “Correct 1” &amp; “Correct 2”</p>
  
  <p>Value 2 = 2005  “Correct 2”, “Correct 3” &amp; “Error”</p>
  
  <p>Value 3 = 400   “Correct 1”, “Correct 2” &amp; “Error”</p>
  
  <p>The Info1 line will therefore be labeled “Correct 2” since that group applies to all values.</p>
  
  <p>Is this possible?
  Formula or VBA are both fine :)</p>