title: How to automate reading excel cells and skip the duplicates?
body: <p>I'm working on this Excel report. It's a bit hard to explain without attaching an example here. So, I will try to put it in manually...Let's call this worksheet A:</p>
  
  <pre><code>ENV    SYSTEM    ACTION     CRQ
  --------------------------------
  PROD   RAC2       PATCH     12345
  DEV    te2ds      STAGE     34672
  DEV    te2ds      PATCH     34294
  PROD   PRAC5      STAGE     47382
  PROD   hq2/DBNAME PATCH     47389
  
  etc....
  </code></pre>
  
  <p>That's just a small piece of the Excel table that I have. 
  And there is another worksheet X:</p>
  
  <pre><code>SYSTEM   DBNumber
  --------------------
  RAC2       30
  te2ds      10
  PRAC5      12
  hq2        3 
  
  etc...
  </code></pre>
  
  <p>So, what I'm trying to accomplish is, I want some sort of a code (preferably, excel formula..which I doubt helps much in this case) to automatically 'Go in --> Read the cell from Worksheet A, SYSTEM column --> find that name from Worksheet X --> put the relative number under DBNumber in to a cell under a new Worksheet( or a worksheet that I specify), next to its right SYSTEM name. --> If that SYSTEM name/number was already copied over then skip that cell. 
  Does it make sense? Thank for all the inputs! I really need some help on this. :)</p>