Pulling Column Info Based on Column Containing Data in Separate Sheet
I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT functions but I am having a hard time figuring out how to make these formulas work with cross sheet references. Anyone able to help me figure this out?
Edit: these are sample sheets as my others have sensitive data on them. One other important piece of information is that some Statuses in my true master list are empty. I would like to have this formula pull only rows containing information as opposed to all of them. Did not think to show that difference when posting original screen shots.
Help Article Resources
Check out the Formula Handbook template!