Forum Discussion
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
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?
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!!
