what is the VBA code for VLOOKUP?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Range("F12").Value = Application.VLookup(vVal, _
Worksheets("Sheet1").Range("A1:F500"), 2,False)
 
Application..VLOKUP(Range("A1"),Range("H1:J100"),2,False)

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
The Basics 4
using vlookup in vba 10
VBA Coding Using VLookup 2
Help With VLOOKUP VBA Script Line 1
Nested If Function to be converted into a user-defined customfunction 1
VBA Code to monitor standard toolbar buttons. 1
Defining a dynamic table_array for vlookup 9

Back
Top