How can I make other categories fill after a name from a dropdown has been selected.

I have a form for users to use that looks like this:

I would like to make it so that when a user pulls their name from the the drop down menu "full name" their email address and phone number are automatically populated. I was thinking I could do this with vlookup from another smartsheet, but I am having problems getting it to work. The other smartsheet would be called Employee List and has the colums User, Number, ext, cell phone, email. Although I only want to reference 2 of those colums for now.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!