Vlookup with multiple matches

%3CLINGO-SUB%20id%3D%22lingo-sub-1219160%22%20slang%3D%22en-US%22%3EVlookup%20with%20multiple%20matches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219160%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20issue%20at%20work%20with%20an%20excel%20code.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20sheet%20one%20i%20have%20all%20of%20my%20sales%20orders%20with%20a%20unique%20key.%20In%20Sheet%202%20i%20have%20all%20of%20my%20sales%20lines%20which%20represents%20all%20lines%20on%20my%20sales%20orders.%20I%20want%20to%20take%20the%20description%20of%20my%20sales%20lines%20(ROW%20I)%20and%20return%20it%20to%20the%20sales%20order%20horizontally%20in%20sheet%201.%20All%20of%20the%20sales%20lines%20has%20a%20reference%20to%20the%20unique%20key%20for%20the%20sales%20order%20it%20belongs%20to.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20very%20easy%20via%20Vlookup%20but%20there%20are%20multiple%20matches%20and%20via%20vlookup%20i%20only%20get%201%20return.%20Numerous%20sales%20lines%20under%20same%20salesorder%20and%20i%20want%20to%20return%20all%20of%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIve%20been%20looking%20at%20the%20Index%20if(Small%3BROW)%20combination%20which%20is%20the%20recommendation%20online%20but%20i%20can%20really%20make%20it%20work...%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPleeease%20help%3A)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1219160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219342%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20with%20multiple%20matches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578047%22%20target%3D%22_blank%22%3E%40Mikkelvb%3C%2FA%3E%26nbsp%3BIf%20you%20have%20the%20latest%20Excel%20(Office365)%2C%20this%20is%20easily%20done%20using%20TRANSPOSE%20in%20combination%20with%20FILTER.%20Have%20look%20at%20the%20attached%20workbook.%26nbsp%3BIf%20it%20doesn't%20work%20for%20you%2C%20it%20becomes%20a%20bit%20more%20complicated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1220630%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20with%20multiple%20matches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220630%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20your%20awesome!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello 

 

I have an issue at work with an excel code. 

In sheet one i have all of my sales orders with a unique key. In Sheet 2 i have all of my sales lines which represents all lines on my sales orders. I want to take the description of my sales lines (ROW I) and return it to the sales order horizontally in sheet 1. All of the sales lines has a reference to the unique key for the sales order it belongs to. 

 

This is very easy via Vlookup but there are multiple matches and via vlookup i only get 1 return. Numerous sales lines under same salesorder and i want to return all of them?

 

Ive been looking at the Index if(Small;ROW) combination which is the recommendation online but i can really make it work...


Pleeease help:) 

 

How do i do this? 

 

2 Replies

@Mikkelvb If you have the latest Excel (Office365), this is easily done using TRANSPOSE in combination with FILTER. Have look at the attached workbook. If it doesn't work for you, it becomes a bit more complicated.

 

Thank you@Riny_van_Eekelen your awesome!