VLOOKUP between two sheets


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!