Excel drop down selection with multiple outputs

[Douglas Laing]

I imagine this is easy, but I need some guidance.

I want a dropdown box to give me a list of suppliers.  When I chose one, other cells in the row will populate with the suppliers phone number, contact person, etc.

I know how to create a dropdown list of suppliers.  Then what?

Thanks for your help.

[#2]

Douglas,

If you have a dataset of the suppliers' info, then you can use some lookup functions such as VLOOKUP to lookup in the dataset, and return the info that you want into another location based on the supplier name of ID.

I leave you with this video to learn that.

[#3]

Thank you. I was able to attain the results I wanted.