Automate switch to contact email

Hi Community! I have a sheet that has a column of usernames (random letters ex OPKAP) that associate with an email address in the column next to it. I am hoping to possibly manage references or vlookup or something so in a different sheet if i input the username it automatically fills in the users email address. is that possible? Or something i can imbed into the main sheet that makes it recognize the username and input the email?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!