Can I change the result of a formula to be blank instead of "#NO MATCH"?
I have a formula that is working as expected - pulling names when it finds them in another sheet - and when the name is not there, the result is "#NO MATCH". I understand the "#NO MATCH" response, but I'm wondering if there is a way for the result to show as blank rather than the words "#NO MATCH". Below is the formula I am using:
=INDEX({23/24 Teacher Talk Attendance Range 1}, MATCH([Teacher Name]@row, {23/24 Teacher Talk Attendance Range 1}, 0))
Best Answer
-
You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".
Answers
-
Yes. You would wrap the whole thing in an IFERROR statement.
=IFERROR(original_formula, "")
-
Where does the error part go in the full formula? Can you type the full formula including the error part here?
Thank you, so much, Paul!
-
You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!