Odd vlookup behavior



I have configured two columns in a sheet with a vlookup column formula. The formula references another sheet in the same workspace and initially works fine. When a new row is added via a form, the two columns show a #nomatch error. I verified the key and the data I'm looking for exists in the reference table so I'm not sure why it is not bringing back any data.

I deleted the vlookup column formulas and reentered them and it worked for the row that was showing #nomatch. When a row was added via the form after redoing it, I encountered the same issue.

Any help would be appreciated.

Thank you,

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!