Pulling data from two sheets
Hi! I have two different sheets that I use for tracking with two different teams. There are some projects that both teams need to work on and I want to pull information from the 2 separate team trackers into 1 joint tracker that shows only the projects relevant to both teams. I'm thinking I could do some kind of search function that if one team's tracker mentions the other team in their project description, that could be an indicator that the project should also populate to my third new tracker, and vice versa for the other team. Is there a way I can do this? I'm having some difficulty with an index/match formula. Thank you!!
Help Article Resources
Check out the Formula Handbook template!