INDEX MATCH and IF Formula

Mariana Fortuna

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

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)