Is it possible to combine IF Function with INDEX & MATCH Function?
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

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

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

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

Thanks! I'll try it.
Help Article Resources
Categories
Check out the Formula Handbook template!