title: Vlookup / Match max min number on different worksheet
body: <p>I have 2 worksheets, one with company data and the other with a min max and answer column.</p>
  
  <p>What i need to do is find out if value in column D in the company data is between the min/max in worksheet 2 output answer in worksheet 2.</p>
  
  <p>Please can someone help.  This is clearly a vlookup question but i haven't got a clue how to do the min/max.</p>
  
  <p>Any help will be greatly appreciated.</p>
  
  <p>worksheet 1</p>
  
  <pre><code>NAME                    TYPE    NUMBEROFEMPLOYEES   Output
  Wetland Plants Ltd      Client  4   
  Capital Management LLP  Clients 3   
  College ltd             Clients 156 
  </code></pre>
  
  <p>Worksheet 2</p>
  
  <pre><code>max         min     output
  100000000   60000   big
  59999       15000   medium
  14999       0       small
  </code></pre>
  
  <p>Cheers guys</p>