Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-468382%22%20slang%3D%22en-US%22%3EAuto%20populate%20cells%20from%20a%20list%20but%20has%20multiple%20orders%20with%201%20order%20no%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-468382%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109398i9DCD1EE6034A734B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22AB276242-92AE-4D6D-83E5-10AC04E9D70B.jpeg%22%20title%3D%22AB276242-92AE-4D6D-83E5-10AC04E9D70B.jpeg%22%20%2F%3E%3C%2FSPAN%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20sheet%20full%20of%20orders%2C%20some%20cells%20have%201%20line%20with%201%20order%20number%20but%20some%20cells%20have%201%20order%20number%20but%20have%20multiple%20lines%20of%20orders%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhich%20formula%20should%20i%20use%20so%20that%20I%20only%20have%20to%20select%20from%20a%20list%20and%20it%20will%20populate%20the%20cells%20for%20that%20order%20or%20orders%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20I%20choose%20order%20no%202%20from%20a%20list%20it%20will%20populate%20cells%20for%20all%20orders%20on%20line%203%20and%204%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-468382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
klraikes
Occasional Visitor

AB276242-92AE-4D6D-83E5-10AC04E9D70B.jpegHi

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies