At Econometricus we deploy advanced matching techniques that range from:
- Exact matching (your vlookup function).
2. Fuzzy matching (Optimized String Alignment).
- Geographic matching (Either Manhattan or Haversine Calculation).
4. Statistical matching (Nearest Neighbor Algorithms).
Based on what you describe, your project may require just a partial or fuzzy match which will report a distance metric that you can track to filter through the matches faster.
Happy to help whenever you are ready!