Auto populate cells from a list but has multiple orders with 1 order no

Occasional Visitor



I have a sheet full of orders, some cells have 1 line with 1 order number but some cells have 1 order number but have multiple lines of orders


which formula should i use so that I only have to select from a list and it will populate the cells for that order or orders?


So if I choose order no 2 from a list it will populate cells for all orders on line 3 and 4


Hope this makes sense



0 Replies