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.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!