Forum Discussion

SorinNeagu's avatar
SorinNeagu
Copper Contributor
Aug 17, 2020

Comparing Two Tables

Hi,

1. I have two tables: let's name them the old one and the new one.

2. The first column in each is the product name.

3. The last column in the old one contains observations. The last column in the new one is empty.

4. Each row is a product with its characteristics. There are common rows in those two tables (products still being working on), some only in the old one (finished products) and some only in the new one (new products).

 May I kindly ask an expert here if you can suggest a function (I can provide an algorithm, but I don't know how to create the function) to compare them, and to transfer the observations from the old table to the new table for the products that are common (so the ones still being worked on; I don't care for the ones finished, because they are finished, and for the new ones there are no observations). I am doing manually this right now, and it's very time consuming.

 

Thank you very much!!

2 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor

    SorinNeagu 

     

    So long as that first column (Product Name) actually contains the names identically typed, you can start by using the  VLOOKUP function.

     

    Another possibility is FILTER (requires the most current version of Excel)...

     

    I'm sure there are other methods. So much depends on what your two sheets look like. Is it possible to post a good example of your sheets?

    • SorinNeagu's avatar
      SorinNeagu
      Copper Contributor

      mathetes 

      Thank you immensely!!!

       

      The truth is that I posted this on behalf of my sister, so I have to ask her (there may be sensitive data). Also, when I discussed with her, she said that the product number was on the first column. It looks like it's a bit more confusing.

       

      Anyhow, thank you very much again for your prompt answer!!

Resources