platinumstorm
New Member
- Joined
- Sep 2, 2014
- Messages
- 2
Hi guys, I've searched all over Google and the internet, maybe with the wrong wording on what specifically I'm attempting to do (not uncommon for me lol). I'll try to explain it the best I can here. I have a workbook called Looper-Dynamic. Within this WB, I have (In_Possession, KFLoopers, Tables, Counts, KFDaily_Win). The In_Possesion sheet is every unit (To keep it general) we physically have on-hand. This sheet has columns for a box number, tray number, serial number, general reason for failure, specific reason, and a customer complaint. (A-F). This sheet grabs information from the KFLoopers file and then sorts it into the aforementioned trays and boxes. The Tables and counts aren't relevant here, so I'll disregard them for now. KFDaily_Win is my sheet that automatically requests the updated text file we receive daily, and updates the units based on that. KFLoopers trims, and narrows down what the KFDaily file contains into the columns I use (Serial, General reason, Specific reason, customer notes). I have units that have multiple General Reasons (Column D) and my In_Possession sheet is using VLOOKUP for each serial number as we scan it in. Obviously, VLOOKUP misses the multiple results, and grabs the first one it "sees". How can I get ALL the results from ONE serial number to either populate next to each other, or create new rows, or otherwise make it obvious that there are more than 1 "hit" per serial number?