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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!