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

mistone

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

Mike TV

@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

@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

@mistone

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

mistone

Thanks! I'll try it.