Cross sheet reference - I would like info in column b on sheet A to appear in column Y on sheet Z

Dan Kirk

Column Y on sheet Z has no data in it. Many of the cells in column b on sheet A are blank.

I've tried

=IF(NOT(ISBLANK({column b on sheet A}), 1, 0))

=({column b on sheet A})

=INDEX({column b on sheet A}, MATCH([column Y]@row, 0))

=INDEX({column b on sheet A})

I would also like it to update when changes are made.

I feel like I'm missing something obvious.

Thanks for any help,

Dan

Find more posts tagged with

Accepted answers

All comments

Sarah Keortge

INDEX/MATCH is definitely the way to go and you just need to adjust the MATCH formula. You'll need to define both the column in sheet Z and in sheet A that match between the two sheets - that's what will be used to look up the correct data in sheet A.

=INDEX({column b on sheet A},MATCH([matching column in sheet Z]@row,{matching column in sheet A},0)

Dan Kirk

Thank you, that worked. I misunderstood the function of MATCH.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.