How can I use INDEX with 2 MATCHes?

Hello,

Could someone guide me to use INDEX with Range from another sheet (single column range (date)) with 2 Matches with range from another sheet ( range 1 is Column A and range 2 is Column B)?

Regards,

Manpreet

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are you able to provide a screenshot? From the sound of it, you are going to want an INDEX/COLLECT instead.

    =INDEX(COLLECT({Date range}, {Column A}, @cell = "column a criteria", {Column B}, @cell = "column b criteria"), 1)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!