Unique dropdown list based on two criteria but...

[Darsk]

Hi Guys,

Having issues with an unresolved problem.

See attached file which has two tabs. First tab shows the table with 3 headers. Criteria 1 (Publisher) would be a dropdown list sourced from the info from the 2nd tab. Then Criteria 2 (Format) would give me another dropdown list based on Criteria 1, from the info on the 2nd tab. Criteria 3 would then give me another dropdown list based on Criteria 1 plus Criteria 2, from the info on the 2nd tab.

Now the catch is I'd like to have this available on each row.

I don't know VBA so was hoping there's a manual process. I've managed to find a solution if I only required one line, but I need up to 10 searches at a time.

And to really test your brains, could the drop list be autosorted and exclude any blanks (listing the descriptions only).

Hoping someone can bring joy to this workers frustrating week.

Darsk.