title: Compare given cells of each row of two tables
body: <p>I am looking to update the last column of one data table with the last column of another data table. This is part of a bigger vba code. The first table spreads from A2 to column K and row "lastrpivot1". The second goes from A1001 to column K and row "lastrpivot2". Beginning with the first row of table 2 (row1001) i have to find the equivalent row in table 1 based on the values in cells A to E.</p>
  
  <p>So cells A to E or frow 1001 have to be compared to cells A to E of row 2, then row 3, then row 4... until a match if found or until row "lastrpivot1". When a match is found, the value in K must return to the K value of row 1001. EX: if AtoE of row 1001 match row AtoE of row 65, then copu K65 to K1001. there shound not be more than 1 match from each table. and if there is no match there is nothing to return.</p>
  
  <p>Then we start this all over for row 1002 (second row of second chart), then 1003, 1004... to lastrpivot2.</p>
  
  <p>I do use vba but i do not know all the functions. this is probably why i cant figure this out.</p>
  
  <p>Thnka you</p>