Dropdown Lists

[spoljar]

Hi Guys. New to this forum and hope there are a few excel gurus that can help me out with this.

What I want is to create 3 dependent drop down lists that eventually gives me one result.
The drop down lists will be on the "Master Sheet" worksheet.

I would like the first drop down lists for Supplier,
this in turn will give me Product,
and this in turn will give me Quantity.

The end result of course will be the Cost, which I would assume I can use a simple index and match.

However, you may notice on the "Product Information" worksheet that there are numerous duplicates there which I don't want showing up when I use the drop down list. In short, I only want each supplier or product or Quantity showing up once depending on which selection I make.

Can anyone help me with this.

[royUK]

Why not just use AutoFilter on the main sheet?

[teylyn]

Hello Spoljar,

it's a bit more complex than that. You need several columns to populate the separate validation lists.

See attached.

[spoljar]

Why not just use AutoFilter on the main sheet?

I eventually want to create a table underneath the cost that will change according to what the cost it. I thought this was the best way to go about it.

Cheers.

[spoljar]

Hello Spoljar,

it's a bit more complex than that. You need several columns to populate the separate validation lists.

See attached.

That is exactly what I am looking for. You are an absolute legend.

Thanks Buddy!