=FILTER for scheduling, spill workaround?
Hey everyone, I feel as though I am doomed here in what I'm trying to achieve here but figured I'd give it a shot.
Above is the end goal where 'customer'/ 'product'/ 'order qty'/ 'ship date' is being populated based on just inputting a sales order number in column A. Each cell in the 'Customer' column is using =FILTER to spill out data into the subsequent columns by finding the sales order number from a separate master sales order sheet and pulling it from that specific column in the 'Sales Order's row.
Of course, above is the cruel #spill reality I am burdened with once I drag the formula cell down so this can be used dynamically. I've used XLOOKUP in the past which worked okay, but if a sales order number had multiple rows of items like "Bike"s order in the end goal picture, it only returns the first value.
=FILTER(SO!$H$2:$L$69,SO!$G$2:$G$69=B6,"") This is the formula I'm using currently, maybe I'm missing something or there's some complicated work around. This sheet is to be used by multiple people of varying technical ability so being very simple is imperative.
Anything is helpful or just let me know if this aint gonna work boys.
[link] [comments]
Want to read more?
Check out the full article on the original site