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?
