Formula Needed

I am tracking attendance for meetings I am doing. I need the DC # to automatically fill in when I type the name in . The data is already in another sheet, I just need the DC # that matches the name to be filled in. I am Including two screenshots. The first is where I need the formula. The second is the sheet the data is in. Thanks for any help.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!