Sure is

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

--

HTH

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


"UofMoo" wrote in
message ...

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