title: How to update one row of a spreadsheet based on a row of another spreadsheet in MS Excel?
body: <p>(For Magento Product Import):</p>
  
  <p>How to update one row of a Sheet based on a row of another Sheet in MS Excel? </p>
  
  <p>I have two Excel Sheets with about 1500 product data. </p>
  
  <p><strong>Sheet_1</strong> has <em>old_sku</em> and product name and <strong>Sheet_2</strong> has <em>new_sku</em> and product name. I want to update the <strong>Sheet_1</strong>'s <em>old_sku</em> based matching them with product name of <em>new_sku</em> of <strong>Sheet_2</strong>.</p>
  
  <p>For example:</p>
  
  <p>In Sheet_1 first product is "Aakash All In 1 350Gm" and its old_sku is 'Aakash-All-In-1-350Gm' while in Sheet_2 the same product's new_sku is 'SNA934'. There are about 1500 products and I need to update their SKUs with new ones so that I can import and update the product catalog in Magento.</p>
  
  <p><a href="https://i.stack.imgur.com/fjahk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fjahk.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/edVKP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/edVKP.png" alt="enter image description here"></a></p>
  
  <p>Is there any quick way I can update column A (<em>old_sku</em>) of <strong>Sheet_1</strong> from column A (<em>new_sku</em>) of <strong>Sheet_2</strong>? While Googling, I came across suggestion using VLOOKUP but I don't know how to perform it in this context.</p>