title: Compare values from one excel workbook to another
body: <p>I have two excel workbooks. <code>Workbook1</code> has list of urls and other i.e. <code>Workbook2</code> has along with list of urls few more columns.</p>
  
  <p>Workbook1:</p>
  
  <pre><code>COLUMN A
  url_list
  url1
  url2
  url3
  url
  </code></pre>
  
  <p>Workbook2:</p>
  
  <pre><code>COLUMN A                            COLUMN B         COLUMN C
  Key Words                           URL              Jan 2015
  Website search Engine Optimisation  url1             72614
  Website search Engine Optimisation  url2             20890
  Website search Engine Optimisation  url3             133968
  Engine Optimisation                 url7             584625
  </code></pre>
  
  <p>I want to compare list of urls from <code>workbook1(Column A)</code> with <code>workbook2(Column B)</code>.</p>
  
  <p>If any url from <code>workbook1</code> is missing in <code>workbook2</code> then it has to be added in <code>workbook2</code> in the end.</p>
  
  <p>For example:
  Now <code>url</code> is not present in workbook2, so it will be add , and will look like this
  Workbook2:</p>
  
  <pre><code>COLUMN A                            COLUMN B         COLUMN C
  Key Words                           URL              Jan 2015
  Website search Engine Optimisation  url1             72614
  Website search Engine Optimisation  url2             20890
  Website search Engine Optimisation  url3             133968
  Engine Optimisation                 url7             584625
                                      url
  </code></pre>
  
  <p>I am using library phpexcel to work with excel sheets in php in windows 7. 
  Also is there any direct excel formula to do so?
  I know with php i can do this.</p>
  
  <p>Thanks</p>