So if you find 004/28136/00 in the components column, ...
Qty Component Parent Parent2 Parent3 Parent4 Parent5 Parent6 Parent7 Parent8 Parent9 004/28136/00 520/34007/04 520/34007/01 520/34007/00
... which agrees with your list as far as it goes. Not what you're looking for?
Last edited by shg; 11-27-2018 at 02:29 PM.
Entia non sunt multiplicanda sine necessitate
Hello, and thank you so far for your help.
It is correct for one branch:
004/28136/00 goes into 520/34007/04
the remaining follows the picture
Screenshot_3.png
I am trying to think if your method could be addressed in another lookup table to find the other occurrences or if a vba procedure was needed to perform the backwards search.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks