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 ...
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!!