How do I correct a #NOMATCH error when the =VLOOKUP formula worked in the initial cell?

Renee Dillard

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

Danielle Arteaga

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.

Renee Dillard

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.