Copy certain data to secondary sheet based on condition
I am struggling with coming up with a formula to do this and it may be as simple as me not fully understanding the INDEX/MATCH function.
We have a Project Intake sheet where projects are initially entered and assigned a project ID. Each project row may be updated several times before the project is approved. Once approved, I'd like to copy some of the row data to an Approved Project sheet.
Also, the Intake Sheet is not static as new projects will be entered. So I want to be able to copy those once they have been approved.
In the example below, ITS001 and ITS002 have been approved so I'd like to copy the Project ID, Project Name and Project Manager to the Approved Project Sheet.
Project Intake Sheet
Approved Project Sheet
The logic seems simple enough (if approved, copy some cell data to new sheet), but I have not figured out the correct formula.
Thank you in advance for any assistance!
Help Article Resources
Check out the Formula Handbook template!