VLOOKUP - cross referencing two data sources

Hi All,

Beginner user here :)

I would like to cross reference a member number on a sheet that is generated by a form to a master list on another sheet to see if that member has submitted the form. This will allow me to check who has not sent in a form so I can send a reminder email.

I'm thinking using the VLOOKUP formula but can't seem to get it to work?

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!