Hello,

I am trying to auto generate a list on a worksheet based on MULTIPLE
conditions in
another i.e.

Worksheet 1 Contains the list below,

tree green america-north sequoia
tree green america-south cedar
tree green america-south tall cedar
tree red asia asiatictree

I want a list to be generated in worksheet2, based on multiple
criterias:
col1: tree
col2: green
col3: left(col3;7)=america

Result would look like:
sequoia row
cedar row
tall cedar row

I need to use a function to make it, not a macro.

I have read several post on using index & small, but I cannot make this
on working...

Thanks a lot for your help