title: How to automate data mapping from two excel sheets
body: <p>I have two excel sheets. One Excel sheet contains the user responses (option selected by the user a/1,b/2,c/3,d/4,e/5) for the survey questions/variables and other file contains the the actual value for each of these options</p>
  
  <p>Please find the example scenario</p>
  
  <p>Excel file 1 contains OUTPUT data as shown below</p>
  
  <p><a href="https://i.stack.imgur.com/jUexL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jUexL.png" alt="enter image description here"></a></p>
  
  <p>Excel file 2 contains INPUT/DICTIONARY data as shown below</p>
  
  <p><a href="https://i.stack.imgur.com/MUp8x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MUp8x.png" alt="enter image description here"></a></p>
  
  <p>I expect my output where the options like a,b,c,d are replaced with actual values</p>
  
  <p><a href="https://i.stack.imgur.com/i0lUZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i0lUZ.png" alt="enter image description here"></a></p>