title: Excel to match the values within two worksheets
body: <p>i need a macro/formula to compare the two cell range in a worksheet and return the corresponding value in the cell.</p>
  
  <p>eg sheet:
  in worksheet 1(sheet1)</p>
  
  <pre><code>AGE Description proof
  1   8   
  2   9   
  3   2   
  4   9   
  5   5   
  6   6   
  7   0   
  8   1   
  9   2   
  10  1   
  </code></pre>
  
  <p>sheet2:</p>
  
  <pre><code>dates   1st 2nd 3rd 4th 5th 6th
  
  0         1  1  2   2   3   3
  1         2  3  5   6   7   8   
  3         4  6  7   8   9   7 
  5         6  7  8   9   10  11
  7         8  9  10  11  12  13
  10       11 12  13  15  16  18
  12       13 15  16  18  19  21
  15       16 30  31  45  46  60
  30       31 33  34  37  38  40
  </code></pre>
  
  <p>from the above example if my range needs my expectation (eg in sheet1 Age: 1 and description: 8 then it should compare it with sheet2 and paste the value as 6th in sheet1 proof column). like these i need to fill all the fields</p>