Lock Vlookup


With the below vlookup, I'm pulling new employee's trainers. However sometimes the trainer changes midway through the class, is there a way to lock in the first trainer that is pulled?

=VLOOKUP([Employee ID]@row, {New Hire Trainer}, 10, false)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!