Display #NO MATCH as other value
I have a vlookup that will sometimes not return a value and instead returns #NO MATCH. I'm trying to create a helper column to translate that #NO MATCH into helpful text for the end user, like "Not Found on Verizon Invoice" to indicate the row exists on our internal tracking sheet but not on our company invoice. I can't seem to figure out how to get a formula to recognize that value to display the text I want it to. How do I get a formula to recognize #NO MATCH being returned instead of a value?
Best Answer
-
Use the IFERROR formula along with your formula. This will tell the cell that if there is any error to show Not Found on Verizon Invoice.
=IFERROR(formula you already have, "Not Found on Verizon Invoice")
Answers
-
Use the IFERROR formula along with your formula. This will tell the cell that if there is any error to show Not Found on Verizon Invoice.
=IFERROR(formula you already have, "Not Found on Verizon Invoice")
-
That worked, thank you!
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!