Help with IF/INDEX/MATCH (I think)
Hi there - I'm looking for a formula that looks at Sheet 2 and if the "Terminated" box is checked, then check the "Not Currently Active" box in Sheet 1, according to the entity name. (Meaning if Happy Co is listed as Terminated in Sheet 2, it would be marked as "Not Currently Active" in Sheet 1.
I appreciate any help you can offer!
Help Article Resources
Check out the Formula Handbook template!