Range("F12").Value = Application.VLookup(vVal, _
Worksheets("Sheet1").Range("A1:F500"), 2,False)

--
Regards,
Tom Ogilvy


"Shan" wrote in message
...
Hi all,
i'm a newbie to excel...
i m looking for VBA code for VLOOKUP function anyone can help?
any good website recommend?


pls kindly help! thanks!