Referencing Dots and Status in another worksheet
I need to reference these two columns from sheet B onto Sheet A.
I want to display worst case from sheet B on Sheet B.
Example: Project 1 on sheet A will display the worst case (At Risk and Red dot) from all rows on sheet B.
What are the two formulas I need? Attempted using an Index formula but was unsuccessful.
Help Article Resources
Check out the Formula Handbook template!