Pulling text through from other sheets
I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score).
The risk and issue Log have a text description (there is a risk that....) and a risk score (5).
I understand cell linking but this won't work as the top 5 risk and issues will change on a regular basis.
Is there a way to perform a lookup (vlookup?) and to pull the top 5 risk and issues through to another sheet automatically?
I need to capture the 'text description' of the risk or issue and the score without having to copy the data from one sheet to another.
Happy to share sample sheets to further explain what I'm trying to achieve.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!