title: How to map the sheet 1 data with sheet 2 with help of Unique ID?
body: <p>I have created an excel sheet with the attributes <code>ID</code>, <code>NAME</code> in one sheet.</p>
  
  <p><strong>SHEET 1:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/zjkKi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zjkKi.png" alt="enter image description here"></a></p>
  
  <p>In another sheet, I have names in a random manner and they have to be mapped to their correct ID with the reference from <code>SHEET-1</code> data.</p>
  
  <p><strong>SHEET 2</strong>:</p>
  
  <p><a href="https://i.stack.imgur.com/rrgDQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rrgDQ.png" alt="enter image description here"></a></p>
  
  <p>The highlighted values are manually entered. Is there any formula that can populate the data automatically.</p>
  
  <p>NOTE: The above data is sample set of data and original data differs in sheet 2. There will be more than 2 columns in the second sheet. </p>