Forum Discussion

Douglas Laing's avatar
Douglas Laing
Copper Contributor
Feb 19, 2018

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, contact person, etc.

 

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

 

Thanks for your help.

excel
Formulas and Functions

2 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 19, 2018

    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.

    • Douglas Laing's avatar
      Douglas Laing
      Copper Contributor
      Feb 24, 2018
      Thank you. I was able to attain the results I wanted.

Resources