INDEX/Match, to not display "#NO MATCH"
=INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0))
How can I get this to NOT display "#NO MATCH" if there is no match?
Best Answer
-
For your use case:
=iferror(INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0)),"")
Answers
-
For your use case:
=iferror(INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0)),"")
-
Thank you again!
-
Hi! What if I already have an IF in the formula? I tried adding IFERROR but it didn't work:
=IF([Student]@row = "Yes", INDEX({GMAT Students Master Sheet Range 5}, MATCH([Client Name]@row, {GMAT Students Master Sheet Range 2}, 0)), "Not student")
If a Student appears in another sheet (GMAT Students Master Sheet) I bring a value from that sheet to the current one. If he is not in the other sheet, it displays "Not student". I want for the ones that are students but do not appear in the other sheet to show blank instead of "#NO MATCH". How can I do that?
-
Hi @anaMG
You'll want to add the IFERROR around just the INDEX(MATCH portion of your formula, like so:
=IF([Student]@row = "Yes", IFERROR(INDEX({GMAT Students Master Sheet Range 5}, MATCH([Client Name]@row, {GMAT Students Master Sheet Range 2}, 0)), ""), "Not student")
Cheers,
Genevieve
-
Thank you Genevieve!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!