Forum Discussion

novakdz's avatar
novakdz
Copper Contributor
Feb 12, 2020
Solved

Help with Formulas (Data validation to Vlookup)

I need help to create a drop down list that is dependent for multiple criteria and will pull the right VLOOKUP based on what is selected for each category.

 

As well as any recommendations for better formatting instead of repeating the same data in a list,

 

thank you for your help.

  • Hi Abiola1,

    Thank you kindly for your help and solution to the problem!

    Is there any way you could
    make the drop down list dependent so they will only pull the information for each vendor.

    Example: Jake only has tableware and 22oz cups but when you select the drop down balloons also come up.

2 Replies

    • novakdz's avatar
      novakdz
      Copper Contributor
      Hi Abiola1,

      Thank you kindly for your help and solution to the problem!

      Is there any way you could
      make the drop down list dependent so they will only pull the information for each vendor.

      Example: Jake only has tableware and 22oz cups but when you select the drop down balloons also come up.