Vlookup or match index?

Hi there,

I'm wanting to know how to autopopulate the [Supplier Rep] column when a particular [Supplier Name] is chosen

I already have a list in a different sheet to reference from as

what would be the correct formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!