INDEX MATCH and IF Formula

Hi Everyone,

Wondering if anyone can help please....i am trying to do a INDEX, MATCH formula based on a condition and it doesn't seem to be working. It works on Excel but not on SS

I have this sheet. In column 2 I have multiple territories that are the same but each has a different date and a different title

When I try to match this sheet with my next sheet it only matches the first title dates so the dates are wrong for TITLE B and C. If i try to add an IF formulas gives me an issue

Any idea how can I solve this please?

Many thanks

Mariana

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You are going to need an INDEX/COLLECT instead.

=INDEX(COLLECT({Dates Range}, {Territories Range}, @cell = [Column3]$1, {Titles Rang}, @cell = $Date@row), 1)

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.