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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!