Pulling data from another sheet (vlookup?)
Hello, I have a question about pulling data from another sheet and I'm hoping there is an easy way to do this.
So I have 2 sheets, one is my main sheet with all my data (collected via form), and another sheet is my roster. On my main sheet, the Employee name column is a single selection drop down menu with my employee names on it. I have another sheet, the Roster, that has two columns (exactly the same as these two in the picture) that have their Name and ID.
I would like to select an Employee name from the "Employee Name" column via drop down selection (it's tied to a form) and have the Employee ID column populate with the ID number from the other sheet based on the selection made.
I'm not very familiar with vlookup, but I think it's probably where I need to start. Or perhaps there is smartsheet functionality that I'm not seeing. Any insight is appreciated!