| | |
excel formula to VB
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Jul 2008
Posts: 1
Reputation:
Solved Threads: 0
Hi
i have a formula which works fine in excel but i cannot get written in VB. Presume in my limited knowledge of VB that it should be if / else if etc. the excel formula is
any help would be much appreciated.
Thanks
Sarah
i have a formula which works fine in excel but i cannot get written in VB. Presume in my limited knowledge of VB that it should be if / else if etc. the excel formula is
VB.NET Syntax (Toggle Plain Text)
=IF(B1995=1,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,8,FALSE),IF(B1995=2,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,7,FALSE),IF(B1995=3,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,6,FALSE),IF(B1995=4,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,5,FALSE)))))
any help would be much appreciated.
Thanks
Sarah
![]() |
Similar Threads
- Excel formula copy (Perl)
- Accessing excel worksheet in a word document (VB macro). (Visual Basic 4 / 5 / 6)
- Excel Help?? Formula Execution?? (Legacy and Other Languages)
- Can someone please help me with an Excel formula?? (Windows Software)
- Trying to create an Excel formula with data from another spreadsheet (Windows Software)
- Microsoft Excel 2000 SP3 If Statement Help (Windows Software)
- need help.. VBA in access and excel.. (Visual Basic 4 / 5 / 6)
- Excel Search Macro Help (Visual Basic 4 / 5 / 6)
- Excel formula (Geeks' Lounge)
Other Threads in the VB.NET Forum
- Previous Thread: using thermal printer auto cutter facility
- Next Thread: VB.NET code
| Thread Tools | Search this Thread |
.net .net2008 2008 access account advanced application array basic beginner browser button buttons center click code combo cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic excel exists fade filter forms generatetags gridview html images input insert intel internet listview map mobile module monitor msaccess net number objects open panel passingparameters pdf picturebox picturebox2 port position print printing problem regex remove right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver survey temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year





