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.
Help Article Resources
Check out the Formula Handbook template!