Is it possible to combine IF Function with INDEX & MATCH Function?

Options
mistone
mistone ✭✭✭✭
edited 12/01/22 in Formulas and Functions

Is possible to combine the IF function (or nested IF Functions) with an INDEX and MATCH Function? I'd like Use the IF function to and a logic to an INDEX and Match search result. It'd be something like... IF The INDEX & MATCH result = 10, Return "YES", Otherwise "NO".

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    edited 12/01/22
    Options

    @mistone

    Yes, you can do that. You can also add it as the true or false response. However, using it as the logic expression should work. If it doesn't recognize 10 as a number, you may have to put quotes around it like "10".

  • mistone
    mistone ✭✭✭✭
    Options

    @Mike TV Thanks! This is encouraging news. Now I just need to figure out how to make it happen. Can you provide the syntax, a formula structure, or an example that could attempt to replicate? I've tried starting with variations of =IF(INDEX({Test Range 1},MATCH([Column1]@row,{Master Reference Sheet - Column 4} ....and then I'm lost. So and guidance with syntax and structure would be much appreciated.

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @mistone

    =IF(INDEX({Test Range 1},MATCH([Column1]@row,{Master Reference Sheet - Column 4},0)=10, then do this, otherwise do that)

  • mistone
    mistone ✭✭✭✭
    Options

    Thanks! I'll try it.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!