I have a question where I want to compare the data ranges between 2 columns for Eg: Column A and Column C I have to compare names matching from Column A against the range in Column C and if there is a match in that specific data row then it should only populate a word "Match" if Column B has a value as 'Case Owner'. I'm new at working with such advanced conditions in Salesforce. Please help!!!

I have a question where I want to compare the data ranges between 2 columns for Eg: Column A and Column C I have to compare names matching from Column A against the range in Column C and if there is a match in that specific data row then it should only populate a word "Match" if Column B has a value as 'Case Owner'. I'm new at working with such advanced conditions in Salesforce. Please help!!!

I am trying to get the information from a field in Accounts to autopopulate in the case page. I tried writing this going off of another formula I found on the site but I cannot get it to work. I get found ')' error Can anyone help!! IF (ISPICKVAL( Account.Account_Priority__c, "Immediate escalation"), "Escalate Immediately", IF (ISPICKVAL( Account.Account_Priority__c, "Level 1"), "Level 1", IF (ISPICKVAL( Account.Account_Priority__c, "Level 2"), "Level 2", IF (ISPICKVAL( Account.Account_Priority__c, "Level 3"), "Level 3",account_priority, ) ) ) )