Pulling data from another sheet (vlookup?)

Dan B.
Dan B. ✭✭✭✭
edited 06/27/22 in Formulas and Functions

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!

Thank you!

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!