I need some help with two Excel sheets.
Excel sheet 1 contains a column (And others) named ArticleID.
Excel sheet 2 have a column called ArticleID and one column named UPC.
In Excel sheet 1 the ArticleID column contain unique numbers, so that no rows contain the same ArticleID.
In Excel sheet 2, ArticleID could be in multiple rows.
I need either a program or a Excel formula that will do the following: (I will need to be able to do this work also at a later stage with similar Excel sheets)
- Merge Excel sheet 2 into Excel sheet 1.
- Excel sheet 2 will match ArticleID and put the UPC number in the correct row. (The same row that contains that ArticleID)
- In my Excel sheet 1, column A-H are in use.
If an ArticleID are present 3 times in Excel sheet 2, the 3 different UPC numbers would be present in row I, J and K in Excel sheet 1, in the row that contains the same ArticleID.
If an ArticleID are present 6 times in Excel sheet 2, the 6 different UPC numbers would be present in row I, J, K, L, M and N in Excel sheet 1, in the row that contains the same ArticleID.
Just ask if you have any questions. Programmers that can do this fast will be prioritized.
102 freelanceria on tarjonnut keskimäärin 55$ tähän työhön
Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL]'s discuss and start right now. Awaiting for your positive reply thanks.
we can match them with vlookup. I am good at excel and can do it correctly. I have been here since 2009 and having lot of experience. Looking for long term relationship
Hi, I can create a formula that can be used easily, instead of complex programming. I'll also explain how to use the same in future. Please send me chat if you need any details.
Hi, I am an Excel automation expert and would be happy to take on your project. Let me know and I can start working on it right away. Regards, Arul