VLOOKUP between two sheets

Options

My reference column in one sheet has an auto numbering format and the same reference in the other sheet is just text but the value is the same. Is that why I'm getting a #NO MTACH error? If so, is there a workaround for that.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!