Formula Using OR - multiple sheets

Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula?

Current formula

=INDEX({3.1 Launched Apps Range 5}, MATCH([Content Name]@row, {3.1 Launched Apps Range 4}, 0)

Find more posts tagged with

Formulas

Accepted answers

All comments

markkrebs

If I'm getting the entire situation here you could check if the first date is blank and then get the other date.

so something like If(isblank(Index(Match#1),Index(Match#2),Index(Match#1))

If both dates are populated and you need both dates then youd need to modify it a bit.

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.