Index/Match with multiple criteria - returning a date


I am trying to return a date from one sheet to another based on 2 criteria that must match.

I have columns COUNTRY, PROJECT TYPE and DATE on both sheets and want to return the Date from the source sheet onto the second sheet based on matching criteria Country and Project type. Is there a way to do that?

Been looking for a solution for my case in the existing chats, but did not seem to find a current answer that works for me.

Thank you in advnce.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!