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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you Genevieve!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!