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

Options
✭✭✭✭
edited 12/01/22

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".

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

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".

• ✭✭✭✭
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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭
Options

Thanks! I'll try it.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!