Auto-fill contact details

Alan Riley

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.

Paul Newcome

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.

Andrée Starå

Hi @Alan Riley

Yes, you can either use a cross-sheet formula and VLOOKUP or a combination of INDEX/MATCH to collect the information from another sheet.

Make sense?

Would that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alan Riley

Haha, to be honest that makes no sense at all but I'll do some research 😊

I've been using smartsheet for some time but only for very basic stuff. I'm trying to use it more effectively to hopefully convince the rest of our team it's a worthwhile investment.

Andrée Starå

@Alan Riley

More information.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Let me know if you have any questions.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

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.

Alan Riley

Thank you both, done it 👍️

Paul Newcome

Happy to help. 👍️

Alan Riley

Nope, it's not working. it does for some, but others it just fills in a random contact name from the list, not the one against the supplier name ?

Paul Newcome

Can you copy/paste the formula directly from the sheet to here?

Alan Riley

=INDEX({Contact List Range 1}, MATCH(Supplier@row, {Contact List Range 2}))

Alan Riley

Think I was missing a '0' at the end ?

Paul Newcome

Yes. The zero at the end tells it to look for an exact match.

Andrée Starå

@Alan Riley

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!