title: Need help to find exact match within a small database
body: <p>In my Excel 2010 database I'm searching for products from several different vendors, but my VLOOKUP function is not retrieving the correct product. For example:</p>
  
  <pre>
  Product ID,    Product Name,    Items,    Colors,
  123,           apple1,          PC,       white,
  **123,         apple2,          Monitor,  silver,**
  **123,         apple3,          Speakers, black,**
  456,           dell1,           Laptop,   red,
  **456,         dell2,           Monitor,  white,**
  456,           dell3,           Mouse,    blue,
  789,           sony1,           TV,       black,
  **789,         sony2,           Speakers, silver,**
  789,           sony3,           Headset,  yellow,</pre>
  
  <p>In the first column there is a drop down menu of <code>Product ID</code>. In the second column there is a drop down menu of <code>Product Name</code> which populates the third and fourth columns. In these I'm using a VLOOKUP function, which is working perfectly in the third column:  </p>
  
  <pre><code>=VLOOKUP(B15,$I$15:$K$23,2,FALSE)  
  </code></pre>
  
  <p>but not in the fourth: </p>
  
  <pre><code>=VLOOKUP(C15,$J$15:$L$23,2,FALSE)  
  </code></pre>
  
  <p>When I search for a <code>Monitor</code> from <code>dell2</code>, it gives me the color "Silver" of monitor from apple and not "White" as I have requested.</p>
  
  <p>How can I search for  the exact match?</p>