title: Excel: Matching values in cells A and B with same values when found in cells C and D
body: <p>I want to match a product number (column A) and a year (column B) for Country A with the same product and year for Country B to be able to compare the trade numbers (columns C and F) between the countries in that year and in that product. When no counterpart is found I want that post to be thrown out. </p>
  
  <p>In the example in the link below I have manually done this until row 22. The row below for instance says that product 030420 was traded in 1995 at value 2.823, but no trade in that product i that year is recorded in country B, so that post I want deleted. Correspondingly, in Country B, trade of product 030420 is recorded in 1994, but there is no counterpart in country A, so that post also should be deleted. Is this doable? The data set is quite big and doing this manually could possibly take forever.</p>
  
  <p>Example:</p>
  
  <p><a href="http://img228.imageshack.us/img228/1214/skrmavbild20110609kl092.png" rel="nofollow">http://img228.imageshack.us/img228/1214/skrmavbild20110609kl092.png</a></p>
  
  <p>Thanks
  Oscar</p>