PDA

View Full Version : Vlookup in vba



KK1966
03-15-2009, 07:02 AM
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 :help

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

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

Thanks you help.

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

mdmackillop
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