title: Excel: How to add one column with another column, row by row?
body: <p>So basically, I have two columns, in two different worksheets that I need to add together.</p>
  
  <p>This may be best explained with an example:</p>
  
  <pre><code>WORKBOOK 1
                A              B         
        _____________________________
     1 |    Unique ID    |  Number   
     2 |         B1      |    2    
     3 |         C0      |    10  
     4 |         D9      |   N/A   
     5 |         9L      |    0   
     6 |         12      |    5  
  
  
  WORKBOOK 2
                A              B         
        _____________________________
     1 |    Identifier    |   Price   
     2 |         Q9       |   $10.00    
     3 |         9L       |    $5.00  
     4 |         B1       |  $299.00   
     5 |         C0       |    $0.99   
     6 |         12       |  $100.00  
  </code></pre>
  
  <p>The columns in <code>wordbook 1</code> are named <code>unique_id</code> and <code>price</code> and the columns in <code>workbook 2</code> are named <code>identifier</code> and <code>number</code>.</p>
  
  <p>Is it possible to do something such as - If <code>unique_id</code> from the first workbook is equal to an <code>identifier</code> within the second workbook, multiply the <code>number</code> and <code>price</code> together. This has to be done for each column/row, and it should somehow either skip or treat the <code>N/A</code> as nothing/zero.</p>
  
  <p>Is something like this possible without the use of macros, and just by using a simple function within a cell? Or is there a far better method than what I am thinking of?</p>