Hello,
I'm looking to create a function that looks across multiple scenarios to give one output. In the screenshot below, columns A-F are going to be data that is hard coded and column G is going to be the output. For example, if column A is different than column D, output should be "GL". If column B is different than column E, output should be "CC". If both column A and B are different than D and E, output should be "GL/CC" and if both of the columns are the same then output should be "NULL". I put in IF formulas for each row, however I can't figure out how to include them altogether. I've been having a lot of trouble with this so any help would be much appreciated!
Thank you!
I'm looking to create a function that looks across multiple scenarios to give one output. In the screenshot below, columns A-F are going to be data that is hard coded and column G is going to be the output. For example, if column A is different than column D, output should be "GL". If column B is different than column E, output should be "CC". If both column A and B are different than D and E, output should be "GL/CC" and if both of the columns are the same then output should be "NULL". I put in IF formulas for each row, however I can't figure out how to include them altogether. I've been having a lot of trouble with this so any help would be much appreciated!
Thank you!
Last edited by a moderator: