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

[melvyndb]

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 are some errors, can somebody guide me along?

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

[rscsmith]

Hi there

Try this Excel function:

Please Login or Register  to view this content.

Note - I found that I had to leave the "" off of the 2010. If you have the values stored as text, you will need to put them back:

Please Login or Register  to view this content.

If in doubt, or you have a mixture, you can get around it by introducing a VALUE command:

Please Login or Register  to view this content.

Here is some code for a VBA function:

Please Login or Register  to view this content.

Best regards, Rob.

[melvyndb]

forgot to comment that the first solution already worked... thanks rob.