title: Drop down list with vlookup in Excel
body: <p>I need to have a selection from a drop down list of parts in (<code>B2</code>, <code>B3</code>, <code>B4</code>,...) auto populate another cell (<code>D2</code>, <code>D3</code>, <code>D4</code>, ...) with the vendor for that part.  I can accomplish most of that with a simple <code>VLOOKUP</code> for <code>Parts_Data</code> table:</p>
  
  <pre><code>=VLOOKUP($B2,Parts_Data,2,0)
  </code></pre>
  
  <p>Unfortunately some of the parts can be purchased from more than one vendor.  When one of those multi vendor parts is selected, I would like there to be another drop down in <code>D2</code>, <code>D3</code>, <code>D4</code>, ... that allows the correct vendor out of the two or three to be selected. </p>
  
  <p>I came up with a clunky solution using <code>INDIRECT</code> and creating dependent drop downs with most of the parts having just one entry for the manufacturer in the second drop down list.  I would like to eliminate this extra mouse click for most of the selections if at all possible.</p>