Help for fantastic vlookup Jindon code

[abjac]

This below code works fantastic also in worksheet with many rows.
I have numbers in sheet2 column A and the names in sheet 2 column B
I put numbers in Sheet 1 column A and when i run the macro it find the match and put in Sheet1 column B.

It works great.

What i would like to have is the same code. But in this case i put the names Sheet 2 column A and the numbers Sheet 2 column B
And in Sheet 1 column A i put names where example 5 is a match. SO when i run the macro it will find the match of the numbers
and put in Sheet column B.
So is like the other way around.
Jindon code as it is now .

Please Login or Register  to view this content.

IN my below test sheet there is 4 names which are the same and i want to find the belonging numbers for them.

Please have a look
Thanks

Sincerely Abjac

[jraj1106]

Hi.

Try this code:

Please Login or Register  to view this content.

[nilem]

Hi Abjac,
you can use VLOOKUP() function
But first remove the gaps in Sheet2. You can do this with macro:

Please Login or Register  to view this content.

[AB33]

Or Jindon's code all in one go

Please Login or Register  to view this content.

[abjac]

HI Thanks for the answer all codes works really good. So its a perfect , fast and competent answer. Thanks allot to all of you.
Sincerely
Abjac