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
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!