I have messed up one of my formulas and don't know how to fix it.


I have accidentally deleted one of my formulas and can't get it working again. Please help. I need to do a vlookup but I keep getting a no match error

=VLOOKUP(Project1, {Project Ref Number}, 1, false)

this is my formula, not sure what the problem is, unless there is something with the reference table. What I am doing is matching a project name to the project number off the reference sheet.

On the reference sheet project number is column 1, project name is column 2 and project manager is column 3.

I will also need to pull the project manager to another column but if figure if I can get this one working then the other will be easy.

The above is the request sheet.

this is the reference sheet that was imported from excel.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!