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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!