FORMULA HELP? max/collect/if

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 😊

Find more posts tagged with

Formulas

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.