Perhaps this will help
Using VLOOKUP Worksheet Function in VBA (#vba)
from a posting by Peter Beach and Tom Ogilvy
http://www.mvps.org/dmcritchie/excel/vlookup.htm#vba

Also do a Google web search and a Google groups search for
SUB application.vlookup
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"kaci" wrote in message ...
Hi all expert,

I would like to do a V Basic program which can do the vlookup function as
below:

If column A contains the value between 0 and 50, then column B will show <=50;
if column A contains the value between 50 and 100, then column B will show
50 -100.. etc...

I have no knowledge in V Basic.. thus.. need the expert here to help me
out...

Million thanks..............