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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!