How do I correct a #NOMATCH error when the =VLOOKUP formula worked in the initial cell?
I used VLOOKUP to reference my feeder sheet for two references. the formulas work for the first cell, but only when i use the data in the first cell of the referenced sheet. There is a Form attached to this sheet so when information is submitted, i want the sheet to autofill missing information from the reference sheet. I have tried entering in information manually to test the formulas but only certain information is populating correctly and the rest of the cells are saying no match
Answers
-
Hard to answer this without seeing your sheet and formula. But, if the error is because the formula is looking for information in a cell that is not yet populated, you can clear the error by putting an IFERROR wrapper around your formula:
=IFERROR(<your formula>), "")
What this will do is leave your cell blank instead of showing #NOMATCH. However, it will also mask other error messages, which makes discovery that your formula is not working / why it is not working difficult, so use with caution. -
Thanks Danielle, that makes sense. I am building out a sheet to roll out FY25 and instead of testing the formulas on existing data, I was adding them to a blank sheet. However, I entered the data needed to trigger the formula's actions when i was receiving these errors.
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!