Help for Programming in Excel

[Guest]

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..............

 

[David McRitchie]

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