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.
Help Article Resources
Check out the Formula Handbook template!