Unfortunately this is hard to solve without the workbook.
Please can you provide us with a sample workbook and detail what the issue is?
As Mavis said it is quite difficult to help without the workbook but let's try to look at the mechanics.
What you (most likely) did is look for the top 5 WOW and then return the value of that.
then you looked for the top 5 YOY and return the value of that.
WOW can have a different top 5 than YOY (which in your case happend).
What you want to do is make a calculation that says if the the area is in the top 5 WOW then give me its YOY value.
It is difficult to give you an exact formula without the workbook.