Find data in other workbook with two conditions

[esukei]

Hello everyone

I am trying to write a VBA macro that searches for the value of column A (Book A') in column A in Book B.
If found I need to check if the value in column B of Book A and the found value in Book B also matches.
If both values match, copy the value of column C (Book B) to column C (Book A)

I think I can do that with 'find' if I would only have one condition, but how can I do this with two?

Thanks in advance.

[esukei]

Was able to solve it myself with something like this:

Please Login or Register  to view this content.

[Sintek]

Here's one way...Both workbooks open...

Please Login or Register  to view this content.

PS...Your solution in post 2 does not represent your sample file setup...

Can also be done without a loop...

Please Login or Register  to view this content.

Tx for rep +