I am trying to create a VLOOKUP formula using information from a custom object.

I am getting the message:  “Error: Function VLOOKUP may not be used in this type of formula.  Can anyone explain why I’m getting this error message and how to resolve?

Name = Text    (Example: ABCD1)

Subscription_Year = Text (Example: 100)

Combined Pricing Code = Text  (ABCD1)

VLOOKUP (

Pricing_Code_Lookup__r.Name,

Pricing_Code_Lookup__r.Subscription_User__c,

Combined_Pricing_Code__c)

I am needing assistance with calculating a future date based on the current date + __ Months.  For example:

Current Date = 12/15/2009

# Future Months = 6

Future Date =  06/15/2010

In Excel, the formula is = DATE(YEAR(12/15/2009),MONTH(12/15/2009)+6,DAY(12/15/2009)

What would the formula be in Salesforce to calculate the future date (e.g. 06/15/2010)?

I was trying to use the BLANKVALUE formula to populate the Opportunity Name in a custom text field if the field is currently blank.  I don't know if I need to create an IF formula at same time since if field is not blank, then ignore.

Every time I create formula I get syntax error.

Here's how far I got

BLANKVALUE (Custom_Text_Field_c, Name)

I thought I had my formula working, but when I combine 2 "AND" IF statements together it breaks. 

IF( Qualifier__c <> OwnerId ,

IF( Users__c < 20, 60,

IF( Users__c < 50, 100,

IF( Users__c < 100, 250,

IF( Users__c >=100, 500,NULL)))),0)

This works fine.

IF (ISPICKVAL(StageName, "Closed Won"),

IF(

Users__c<20,150,

IF(

Users__c<50,300,

IF(

Users__c<100,750,

IF(

Users__c>=100,1500,0)))),0)

This works fine.

My issue is that I'm trying to combine the IF statements in each of the first 2 sets of formulas.

I am trying to create a complex nested IF formula, but I keep getting an error 'invalid parameters'.  Can anyone see what is incorrect?

IF (ISPICKVAL(StageName, "Closed Won"),
IF( Qualifier__c <> OwnerId ,
IF(
Users__c<20,150,
IF(
Users__c<50,300,
IF(
Users__c<100,750,
IF(
Users__c>=100,1500,0
)
)
)
)
),
0
)

I am trying to revise a formula to do the following:  When Opportuntiy = Closed Won, display a $$ based on the value in the custom field called 'Users'. 

If users <20   use $150

If users <50   use $300

If users <100 use $750

If users >=100 use $1500

My issue:  I'm getting a formula error that I can't resolve.

Any help would be appreciated.

I'm currently an SFDC Administrator and Power User.  However, I would like to teach myself to become a Force.com developer.  I don't have any programming background and wonder what are the best steps to learning it.

I have a developer account and have read Force.com Fundamentals Guide, but that's it.

Any advice is appreciated.

I'm currently an SFDC Administrator and Power User.  However, I would like to teach myself to become a Force.com developer.  I don't have any programming background and wonder what are the best steps to learning it.

I have a developer account and have read Force.com Fundamentals Guide, but that's it.

Any advice is appreciated.

I am trying to create a VLOOKUP formula using information from a custom object.

I am getting the message:  “Error: Function VLOOKUP may not be used in this type of formula.  Can anyone explain why I’m getting this error message and how to resolve?

Name = Text    (Example: ABCD1)

Subscription_Year = Text (Example: 100)

Combined Pricing Code = Text  (ABCD1)

VLOOKUP (

Pricing_Code_Lookup__r.Name,

Pricing_Code_Lookup__r.Subscription_User__c,

Combined_Pricing_Code__c)

I am needing assistance with calculating a future date based on the current date + __ Months.  For example:

Current Date = 12/15/2009

# Future Months = 6

Future Date =  06/15/2010

In Excel, the formula is = DATE(YEAR(12/15/2009),MONTH(12/15/2009)+6,DAY(12/15/2009)

What would the formula be in Salesforce to calculate the future date (e.g. 06/15/2010)?

I was trying to use the BLANKVALUE formula to populate the Opportunity Name in a custom text field if the field is currently blank.  I don't know if I need to create an IF formula at same time since if field is not blank, then ignore.

Every time I create formula I get syntax error.

Here's how far I got

BLANKVALUE (Custom_Text_Field_c, Name)

I thought I had my formula working, but when I combine 2 "AND" IF statements together it breaks. 

IF( Qualifier__c <> OwnerId ,

IF( Users__c < 20, 60,

IF( Users__c < 50, 100,

IF( Users__c < 100, 250,

IF( Users__c >=100, 500,NULL)))),0)

This works fine.

IF (ISPICKVAL(StageName, "Closed Won"),

IF(

Users__c<20,150,

IF(

Users__c<50,300,

IF(

Users__c<100,750,

IF(

Users__c>=100,1500,0)))),0)

This works fine.

My issue is that I'm trying to combine the IF statements in each of the first 2 sets of formulas.

I am trying to create a complex nested IF formula, but I keep getting an error 'invalid parameters'.  Can anyone see what is incorrect?

IF (ISPICKVAL(StageName, "Closed Won"),
IF( Qualifier__c <> OwnerId ,
IF(
Users__c<20,150,
IF(
Users__c<50,300,
IF(
Users__c<100,750,
IF(
Users__c>=100,1500,0
)
)
)
)
),
0
)

I am trying to revise a formula to do the following:  When Opportuntiy = Closed Won, display a $$ based on the value in the custom field called 'Users'. 

If users <20   use $150

If users <50   use $300

If users <100 use $750

If users >=100 use $1500

My issue:  I'm getting a formula error that I can't resolve.

Any help would be appreciated.