Find with 2 criteria to be met

[retos110]

Hi

Is it possible to have 2 criteria in the what part of find? I have tried the & and it does not work

At the moment I have a find in an if statement based on the other find ie:
find criteria1
if so find criteria2

Thanks

Please Login or Register  to view this content.

[JapanDave]

I am not sure if this is what you are after, but

Please Login or Register  to view this content.

Edit: Of coarse replace the cells with the criteria you are after.

[retos110]

Hi

Thanks for the response. I tried that and its not quite what Im looking for. What I would want it to do is search for 2 seperate criteria simultanously. Something like this which doesnt work:

Please Login or Register  to view this content.

Thanks again
Mike

[rylo]

Mike

Can you attach an example workbook to better explain what you are trying to achieve.

rylo

[JapanDave]

I agree with rylo, that will help makes things a little clearer.

[retos110]

Hi Rylo

Not sure how to attach a file but here is the code. Essentially, in a cell Im trying to find a 5 digit number, for example 12621 and then looking for the word enbl

34:1 1262102 Enbl

I have it right now to look for the 5 digit number and if its found look for enbl. What I would like to do is have look for both the 5 digit number and the word enbl simultaneously in one find statement. Is this possible?

Thanks
Mike

Please Login or Register  to view this content.

[JapanDave]

Are both values in separate ranges? This sounds like advanced filter would be a better path to go.

BTW, you can post an attachment by going to advanced post> Manage attachments> upload file from PC.

Dave

[rylo]

Hi

OK your what is going to be something like

Please Login or Register  to view this content.

From your code, I think the 12621 is actually the variable v so it would be

Please Login or Register  to view this content.

HTH

rylo

[retos110]

Hi again

The asteriks worked perfectly- just tested it. There was a very small chance the product code would slip though using my code

Thank you and thanks for all the help this forum has provide

Mike