Autofill data from another sheet



I am trying to autofill the instructor number from another sheet based on the assigned instructor on the calendar sheet. In the screenshot example: I want "InstA - Code" to autofill with the corresponding number for the name entered in "InstA - Name". "InstA - Code" value should be pulled from another sheet. Is VLOOKUP the correct formula to use? I've tried multiple times but keeps coming back with invalid data.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!