Forum Discussion

klraikes's avatar
klraikes
Copper Contributor
Apr 17, 2019

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

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

No RepliesBe the first to reply

Resources