How to pull data from another sheet?

The formula I tried is:

=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 5}, DNumber@row), 1)), "")

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you getting an error or an unexpected output?

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.