excel formula to VB

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jul 2008
Posts: 1
Reputation: sarah424 is an unknown quantity at this point 
Solved Threads: 0
sarah424 sarah424 is offline Offline
Newbie Poster

excel formula to VB

 
0
  #1
Jul 21st, 2008
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

  1. =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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the VB.NET Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC