If/Or with an Index Match
My formula is able to locate from a reference sheet the return value of the HC Request Status1 as a match, however I need to add that when a [Job Class] = "Associate" the HC Request Status = Approved. I am not sure how to correct my formula as I am getting an error 🤨 "unparseable"
Help Article Resources
Check out the Formula Handbook template!