Forum Discussion
Lycias
Jul 12, 2023Copper 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 value using year in column J, and the indicator value is in column L. Please see attached dummy data.
Thanks,
Lycias
See the attached version.
13 Replies
Sort By
The formula is a bit more complicated since all values in your sample worksheet are text.
See the attached version.
- LyciasCopper ContributorThanks, Hans. Is it possible to have this as one formula that I can use in a column in another sheet to pull this value? I just want the data value in one column for all countries?