View Full Version : Vlookup in vba

03-15-2009, 07:02 AM

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 thats 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 :help

03-15-2009, 07:50 AM
Please post a small sample with some data.

03-15-2009, 08:13 AM
Dear mdmackillop

Thanks you help.

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

03-15-2009, 09:12 AM
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