FORMULA HELP? max/collect/if

Stacy Meadows

I am trying to get information from another sheetA to sheetB

I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB

Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏

Please bear in mind new rows are added to sheetB every week

Thanks 😊

Mike TV

@Stacy Meadows

Can you provide an image of SheetA data (hide any sensitive data) and what the expected output to SheetB would be based on that data shown in SheetA?