title: Excel dropdown with name/value pairs
body: <p>I have workbook with 2 worksheets.</p>
  
  <p>"Sheet2" has two columns:</p>
  
  <pre><code>|    A    |      B        |
  +---------+---------------+
  |  code1  | description 1 |
  |  code2  | Descr 2       |
  </code></pre>
  
  <p>Sheet1 has several columns, one of them (column D) is <strong>code</strong>. In this column i need a "drop box", what</p>
  
  <ul>
  <li>will show column Sheet2!B (the descriptions), and when the user selects one description</li>
  <li>will enter the <code>code</code> from the col:A.</li>
  </ul>
  
  <p>It is possible to do <code>without additional helper column</code> in Sheet1? (Excel 2010)</p>
  
  <p>So, need something what is dead simple in html:</p>
  
  <pre><code>&lt;select&gt;
    &lt;option value="code1"&gt;Description 1&lt;/option&gt;
    &lt;option value="code2"&gt;Descr 2&lt;/option&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>when when the user selects "Descr 2", the form get "code2".</p>
  
  <p>This question probably is an duplicate - but i'm not sure - to:
  <a href="https://stackoverflow.com/questions/10580581/how-to-create-dropdown-with-multiple-columns-in-excel">How to create dropdown with multiple columns in excel</a>, but the only answer to it pointing me to an <a href="http://excelsemipro.com/2011/05/a-dynamic-dependent-drop-down-list-in-excel/" rel="noreferrer">external site</a> where the solution is for another problem.</p>
  
  <p>Added a screenshot for more precise explanation:
  <img src="https://i.stack.imgur.com/QPLMv.jpg" alt="enter image description here"></p>