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

[klraikes]

Hi

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

Thanks