Create Data validation list from matched criteria value results

[lukeeb]

Please see attached example workbook. I’m trying to figure out how to create a Data validation list that will look up two criteria values and populate a list with all results.

In the example workbook on sheet “Main” I’d like the Data Validation lists in the yellow marked area, for example cell “B4” to look up the location value in cell “B1” and the product value in cell “A4”, match these two values (LO01 & BBT20) in sheet “Data” column “A” & “B” and return values of column “C” and use the results as the Data Valuation list in cell “B4” on sheet “Main”.

In this example sheet “Main” cell “B4” would result in a Data Validation list of the following;

DD0012.01
DD0012.02
DD0012.05

Thanks in advance

Luke