Hi,
I would love to help you with your formula.
I would do this with a combination of the INDEX and MATCH functions, using an array formula. I would be happy to walk you through the solution.
A little background - I am a reporting analyst by trade and I have over 8 years' experience building automated reports in Excel using advanced formulas and macros/VBA.
I am US-based and bring a strong professional and educational background. I encourage you to check out my profile.
I look forward to discussing this project with you soon.
Best regards,
Marcelo