title: How to create dropdown with multiple columns in excel
body: <p><img src="https://i.stack.imgur.com/ejwEH.jpg" alt="enter image description here">!
  Hi I am using Excel 2003. I need to add data validation to a column, it should display the two columns in the cell, when user selects, the 1st column value should be displayed in cell.</p>
  
  <p>Ex:</p>
  
  <blockquote>
    <p>Col1 Col2<br>
    IND India<br>
    CHI China</p>
  </blockquote>
  
  <p>Column - display to select</p>
  
  <blockquote>
    <p>Column<br>
    IND-India<br>
    CHI-China</p>
  </blockquote>
  
  <p>after selecting <code>CHI</code> the <code>China</code> or <code>CHI</code> will be displayed in the cell.</p>
  
  <p>Is there any possibility to do the process in Excel.</p>
  
  <p>Thanks in advance for any help...
  <img src="https://i.stack.imgur.com/ejwEH.jpg" alt="enter image description here"></p>