VLookup in VB?

[UofMoo]

Is there a way to access functions in a sub ?
i'd like to use vlookup in one of my VB modules...
thanks in advance

[Norie]

Take a look at the WorksheetFunction method of the Application object.

It let's you access most worksheet functions in VBA.

By the way using Vlookup in VBA can sometimes be a problem, if errors are returned by the function VBA won't like it.

[Bob Phillips]

Sure is

ans = Application.VLOOKUP(val,rng,2,False)

--

HTH

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


"UofMoo" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a way to access functions in a sub ?
> i'd like to use vlookup in one of my VB modules...
> thanks in advance
>
>
> --
> UofMoo
> ------------------------------------------------------------------------
> UofMoo's Profile:
http://www.excelforum.com/member.php...o&userid=26485
> View this thread: http://www.excelforum.com/showthread...hreadid=397602
>

[WhytheQ]

or worksheetfunction.vlookup(val,rng,2,False)


Bob Phillips wrote:
> Sure is
>
> ans = Application.VLOOKUP(val,rng,2,False)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "UofMoo" <[email protected]> wrote in
> message news:[email protected]...
> >
> > Is there a way to access functions in a sub ?
> > i'd like to use vlookup in one of my VB modules...
> > thanks in advance
> >
> >
> > --
> > UofMoo
> > ------------------------------------------------------------------------
> > UofMoo's Profile:
> http://www.excelforum.com/member.php...o&userid=26485
> > View this thread: http://www.excelforum.com/showthread...hreadid=397602
> >

[Bob Phillips]

Easily handled,

ans = application.vlookup(....
If Iserror(ans) Then
...

or

On Error
ans = WorksheetFunction.VLookup(...
On Error Resume Next

If IsEmpty(ans) Then
...

--

HTH

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


"Norie" <[email protected]> wrote in
message news:[email protected]...
>
> Take a look at the WorksheetFunction method of the Application object.
>
> It let's you access most worksheet functions in VBA.
>
> By the way using Vlookup in VBA can sometimes be a problem, if errors
> are returned by the function VBA won't like it.
>
>
> --
> Norie
> ------------------------------------------------------------------------
> Norie's Profile:
http://www.excelforum.com/member.php...o&userid=19362
> View this thread: http://www.excelforum.com/showthread...hreadid=397602
>

[UofMoo]

Thanks everyone, I think i got it to work with your help!
You're the best