VBA find row for double conditions

[Bundi999]

Dear all,

I would once again really appreciate your help on the following below:

I need to find the row number when two conditions are met:

1. First, find in column 23 the value x
2. Second, find in column 91 the value shop

Wheb I run the code, it doesnt work yet. Do you have any tips?

Thanks!!

Please Login or Register  to view this content.

[dflak]

I am not quite sure of the requirement, but this code will find where "x" is found in column 23, and then starting at that row, look for "shop" in column 91.

Please Login or Register  to view this content.

[yujin]

I guess Bundi wants the row where column 23 has "x" and column 91 has "shop".
Then, try the code below.

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[Bundi999]

yujin, your code works great! THank you all for your help!

[yujin]

You are welcome, Bundi. Thank you for your feedback.
Personally, jindon's code, using an array, interests me.

[Bundi999]

Dear Jindon,

Indeed, your code works superfast with the same principle, very smart indeed.

I just have one stupid question; iso returning a message box with the line row, can a just be assigned with the row found and stop therafter?

Thanks!!!!!

[Bundi999]

Your help would be highly appreciated!

[jindon]

You mean like this?

Please Login or Register  to view this content.