Filter data by multiple drop down lists

[Nikolay.V.Petrov]

I have a worksheet with the following columns:
Item name, Item type, Item size + some other columns

On the second worksheet I have the same columns in diferent order (Item
type, Item size, Item name) but at every column I need drop down lists.
I use data validation to produce the list for the items in the 'Item
type' & 'Item size' columns. For the 'Item name' column I need a drop
down, which is list, filtered by the previous two columns.
Like first I select 'Item type' then 'Item size' and in the drop down
list in clomun 'Item name' should appear only items which are of the
selected types and size.
After the item in third column is selected i'm going to do some
vlookups.
The behaviour is like the Auto Filter, but I need this on separate
worksheet, because i am going to combine it with data from other
sheets.

Any idea how to achieve this?

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Nikolay.V.Petrov]

Allready looked at it.
not what I need.
tried to make something similiar, which fits my case, but no luck