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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!