Forum Discussion
Steve099
Mar 26, 2021Copper Contributor
Looking for a way to Merge Rows From One Sheet based on Serial Number to be added to another sheet
I have on Sheet in excel with many rows and columns of data. Column A has serial numbers with no duplicates. I have another sheet with different rows and columns of data and column A also has sera...
Steve099
Mar 29, 2021Copper Contributor
Thanks for the suggestions. Could I also use INDEX (Match or is vlookup better?. I added an example of what i have.
Riny_van_Eekelen
Mar 29, 2021Platinum Contributor
Steve099 Sure, I believe the attached file contains a possible solution in Sheet1, from column BO and onwards.