Forum Discussion

Lycias's avatar
Lycias
Copper Contributor
Jul 12, 2023
Solved

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 value using year in column J, and the indicator value is in column L. Please see attached dummy data.

Thanks,

Lycias

13 Replies

Resources