Forum Discussion
Mikkelvb
Mar 09, 2020Copper Contributor
Vlookup with multiple matches
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 o...
Riny_van_Eekelen
Mar 10, 2020Platinum Contributor
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.
Mikkelvb
Mar 10, 2020Copper Contributor
Thank youRiny_van_Eekelen your awesome!