how to combine multiple conditions with search functions and macro the function

Hi all,

I am finding ways to conduct a search for rows with multiple conditions.

e.g.

2010	cat10	closed	yes
2012	dog20	closed	yes
2010	cat15	closed	yes

I need to find 2010,cat,closed, yes as my conditions. Do note that cat has cat10 and cat15, but I want to search anything with cat. so effectively, I will have 2 rows with that condition.

my method:

Please Login or Register  to view this content.

but there is some errors, can somebody guide me along?

I am thinking of seperating the functions so that macro can work, but not sure how.