Forum Discussion
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 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 youRiny_van_Eekelen your awesome!
