Atanas Kisyov
New Member
- Joined
- Dec 10, 2019
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello guys!
I have a problem that I cannot go around and I really hope someone can help me.
I have two tables with material information that look like this:
Table1
Table2
The first column is the finished good number. I have different finished good numbers but they are made with the same materials.
In some cases not all materials are in the same order, so I decided to sum all the numbers to find matches.
The problem here is that VLookup only finds the first match.
And the result is:
But I need it to be like this:
Can someone help me with this problem?
I have a problem that I cannot go around and I really hope someone can help me.
I have two tables with material information that look like this:
Table1
Table2
The first column is the finished good number. I have different finished good numbers but they are made with the same materials.
In some cases not all materials are in the same order, so I decided to sum all the numbers to find matches.
The problem here is that VLookup only finds the first match.
And the result is:
But I need it to be like this:
Can someone help me with this problem?