Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help for Programming in Excel
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.............. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help for Programming in Excel
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.............. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Programming | New Users to Excel | |||
VBA excel programming | Excel Programming | |||
Excel Programming Help | Excel Programming | |||
Excel Programming in VB | Excel Programming | |||
Excel Programming. | Excel Programming |