Vlookup in vba

[KK1966]

Hi

I wanted help to Vlookup in Vba
Situation is there

Sheet1” COL, A2 to A which is a customer named COL B2 to B is the TEL and COL C is contact person.( data is too much about 6500 or above and that’s are past years ago old)

Sheet2” Col A is the current own customers, how do I made VBA to Vlookup base the customer to match (since might typing mode are diffidence) then sheet2 COL B” = Tel, COL C” = the contact persons ?

I want to use Vlookup in a vba module, but i can't figure it out how to do this...

Please help

[mdmackillop]

Please post a small sample with some data.

[KK1966]

Dear mdmackillop

Thanks you help.

attached is samples,
Sheet1 is a old data
sheet2 is exsisting cust ..

[mdmackillop]

I don't see how this could be coded to give reliable results. Here is a userform which will allow names etc. to be selected and put against the new names which might be of use in a one-off exercise