VLOOKUP to another Sheet is returning #NO MATCH



Hoping you can help :-)

Relatively new to Smartsheet but very experienced in excel.

I am trying to do a VLOOKUP from one sheet to another, however the formula keeps returning #NO MATCH.

The only issue I can see is that the cell I am looking up (Induction Status) says Used in Formula <unknown sheet> Do you have any idea why this is showing?

I am the Owner of the original sheet and an Admin on the sheet I am looking up to.

Please see attached file with screenshots.

Many thanks,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!