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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!