Macro countif in 1st sheet and Vlookup in 2nd sheet result should be last row of each part number

[dharmadme]

Hi friends,

I am trying to create set of macro functions for my work.

part of macro i need countif function in sheet 1

sheet 1

A column L Column
Part Number Countif
N8081159 5
N8081159 5
N8081159 5
N8081159 5
N8081159 5
N2080649 4
N2080649 4
N2080649 4
N2080649 4
G3070199 3
G3070199 3
G3070199 3
52119612 2
52119612 2
0339350 1
0.015.3550 4
0.015.3550 4
0.015.3550 4
0.015.3550 4


in sheet 2 same part numbers with different count
but i need sheet 1 count in last row of each part number in sheet 2 with vlookup...

Sheet 2

A column L column
Part Number vlookup with sheet1
N8081159
N8081159
N8081159 5
N2080649
N2080649 4
G3070199
G3070199 3
52119612 2
0339350
0339350
0339350 1
0.015.3550
0.015.3550 4


Part Numbers are in sorted so it will be ordered set.

i hope you can understand.
please provide solution