VLOOKUP to another Sheet is returning #NO MATCH

Options

Hi

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,


JW


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!