title: Create Data Validation(DropDown) based on certain criteria
body: <p>All I want to do is display data in a data validation(DropDown) based on certain criteria. Is it really that difficult to display A8:A13 where E8:E13=Vehicle ???
  I know im very new to excel, but this just seems like im being stupid!</p>
  
  <p>I have this formula(Which is a name range), it displays the correct data, but ONLY based on the value from another cell:</p>
  
  <pre><code>=OFFSET('Fleet List'!$A$9,MATCH($A$8,'Fleet List'!$A$9:$A$13,0)-1,1,COUNTIF('Fleet List'!$E$9:$E$13,"Vehicle"),1)
  </code></pre>
  
  <p>Ive tried playing with INDEX and OFFSET, but not coming right, possibly because I dont understand how they fit together :( Im feeling real dumb today and about to start punching my screen...</p>
  
  <p>This is how my table looks:</p>
  
  <pre><code>|Fleet No.|Reg No.|Vehicle Type|
  
      A1       ABC1     Vehicle
      A2       ABC2     Vehicle
      B1       XYZ1     Trailer
  </code></pre>
  
  <p>Now all I want to do is display a list for Fleet No. from Sheet2 Where Vehicle Type = Vehicle, in Cell A1 in Sheet1.</p>
  
  <p>It cant be that complicated in Excel can it ?</p>
  
  <p>You may laugh at me, but I just really need some help. Thanks in advance! </p>