Odd vlookup behavior

Khari Shiver

Hello,

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,

Devin Lee

VLOOKUP can have issues when new rows are added due to having the column number in the formula. Start using INDEX/MATCH instead. https://help.smartsheet.com/function/index

Devin Lee

VLOOKUP can have issues when new rows are added due to having the column number in the formula. Start using INDEX/MATCH instead. https://help.smartsheet.com/function/index