Streamline Excel PO Pairing

I need help to efficiently pair PO numbers with accounts in Excel. Currently, I do this manually using Excel functions, and I'm looking for a more effective solution.

Key Tasks:
- Analyze current manual process
- Develop a streamlined method, potentially using Excel functions, VBA, or other tools

Ideal Skills:
- Proficiency in Excel, including advanced functions and VBA
- Experience in process optimization
- Attention to detail and problem-solving skills

Looking for a solution that saves time and reduces manual effort.