Auto-fill contact details

I have a 'drop-down' column with lots of different suppliers (Company Names) in the drop-down list.

My next column is 'supplier contact', next column ' supplier contact number'.

Is it possible to get the 2 adjacent columns to auto-fill with the correct contact and contact number according to the company name selected ?

I understand I'll need to input the details the first time, but want to automate it.

Thank you for any help.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Basically you would build out a table that has the Supplier, Contact, and Contact Number listed out in the rows.

    Then you would use a formula such as

    =INDEX({Table Sheet Contact Column}, MATCH(Supplier@row, {Table Sheet Supplier Column}, 0))

    Then update the second range to cover the Contact Number column in the table.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!