Forum Discussion
Lycias
Jul 12, 2023Brass Contributor
Excel look up values and select most recent year
Good day, I want a formula that look-up an indicator in could D, for a specific age group in column F for a specific country using the country ISO code in column H, then retrieves the most recent va...
- Jul 12, 2023
See the attached version.
HansVogelaar
Jul 12, 2023MVP
See the attached version.
Lycias
Jul 12, 2023Brass Contributor
Thanks a lot, Hans. This works perfectly fine.