using of vlookup in vba

[grkchakri]

Hi All

I have a sheet1 with data, Sheet2 with a command button (vlookup) , Sheet3 shows the results.
I have written the following code but it throws errors regarding 1004. It worked for some time and then
suddenly started throwing up errors.

The sheet 1 contains

a1: country code
b1: country name
c1: Hockey Players
d1: Footlball Players
E1: Cricket Players

Please Login or Register  to view this content.

dd.png

[tuongtu3]

Both lines work for me when I put this line in case the Country is not found:

Please Login or Register  to view this content.

[grkchakri]

Check the file, i have attached, It gives the error message even when the country code exists on sheet1.
command button is on sheet2, while results should appear on sheet 3.

Many thanx

[tuongtu3]

Try the sample in attached.

Regards,
tt3