Howto: Vlookup looping (for each...next?). Advise needed about Vlookup loop technique

[Wino]

Hello, I have a slight problem.
I have data in a pivottable which I want to compare with another table.

The lastcolumn+1 of the pivottable needs to get data from another table.

I have this for an example:

Please Login or Register  to view this content.

Can anybody give me leads on how to solve this?

Would be appreciated!!


BONUS:
I defined my Lastcolumn succesfully:

Please Login or Register  to view this content.

[royUK]

Your thread title bears no resemblance to the problem

[Wino]

Thread title edited. Thx for the reply, hope this will lead to a couple of advises.

[Wino]

Maybe to make the problem more easy to understand:

How to make this code work with dynamic ranges?

Please Login or Register  to view this content.

And: "LookFor" as well as "rng" needs to be dynamic....

[Wino]

Nobody got any usefull input?
Still haven't got this working.

[Wino]

Ok, let me give the final solution.
Looping is not necessary it seems.

anyway, solution is this code:

Please Login or Register  to view this content.