Move data based on multiple information

Copper Contributor

How do I get the information on sheet 4 Accounts sold and Cases Depl to fill in on Overview sheet using the national account and item? Capture3.PNGCapture4.PNG

1 Reply

@chaserunyan 

 

If you have the newest version of Excel, then FILTER should do it for you.

 

Here's a video that does a great job of explaining FILTER, what it does and how to use it. Come back and ask for more help if this doesn't work for you.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, but were limited to power users. With Dynamic Arrays we have rebuilt the calc engine, effectively turning all formulas into array formulas ...