Hey all. I'm trying to pull info from one sheet to another if two cells match and getting #INCORRECT ARGUMENT SET. Any help would be greatly appreciated!
=VLOOKUP([Opportunity Name]@row, {PMO Capacity Opportunity Name}, 21, false)
I have discovered that index(collect seems to work much better when using cross sheet references as even if someone moves a column it still pulls in the data you want.
=Index(Collect({PMO Capacity Opportunity Name},{PMO Capacity Opportunity Name},[Opportunity Name]@row),1)
Hi @Christy Kooiman
When I first started working on formulas across sheets, I hadn't realised I needed required permissions.
Once that was fixed, I then realised I needed to click on the Reference Another Sheet when building the formula, rather than just typing the curly brackets around the sheet name.
Let us know if this experience doesn't help you, or if you're still getting the error message #INCORRECT ARGUMENT SET
I actually created both sheets so I am admin on both, and I do click reference another sheet for this, and still getting #INCORRECT ARGUMENT SET unfortunately. :(
That did it!! Thank you so much Hollie!!
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.
