Data Validation and dependant drop downs

Question

I want to generate a form so that users choose a supplier from a drop down ( I can do this bit) and then another drop down only gives them products relating to that supplier

I've tried a number of different "INDIRECT" and "MATCH" functions but nothing seems to work quite right

Answer 1

THANK YOU !!!! it worked :-)

Answer 2

See supplier-product-dropdown.xlsx

Answer 3

Hi Hans - thanks I've tried but I think I'm running out of talent :-)

supplier- product sheet

here is a link to a stripped back version of the master data

I want to use a different sheet to have a little lookup form for users to choose a supplier from a drop down, and a second drop down gives only th products from that supplier

fingers crossed

Answer 4

See Excel Dependent Drop Down Lists from Sorted Table with OFFSET.

If you can't make it work:

Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.