ExcelBanter - what is the VBA code for VLOOKUP?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - what is the VBA code for VLOOKUP? (https://www.excelbanter.com/excel-programming/324487-what-vba-code-vlookup.html)

Shan

what is the VBA code for VLOOKUP?

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!

Tom Ogilvy

what is the VBA code for VLOOKUP?

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!

Bob Phillips[_6_]

what is the VBA code for VLOOKUP?

Application..VLOKUP(Range("A1"),Range("H1:J100"),2 ,False)

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)

"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!

All times are GMT +1. The time now is 12:03 AM.