Forum Discussion
Excel drop down selection with multiple outputs
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, cont...
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.
- Thank you. I was able to attain the results I wanted.
