Help with Formulas (Data validation to Vlookup)

[novakdz]

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.

[#2]

@novakdz 

Hello, kindly see the attached solution and the pasted caption. The drop-downs are in cells I2:L2. The VLOOKUP result is in cells M2:N2

[#3 · Accepted solution]

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.