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 26, 2023MVP
I am confused now. The formula in this sample workbook returns "id" indicating that there is no match.
This is because
- This is not the formula that I proposed.
- Unlike the formula that I proposed, it does not take into account that column J contains text values, not numbers.
Why did you decide to use a different formula?
By the way, the correct version of the formula that you used would be
=IFERROR(--INDEX($L$2:$L$100, MATCH(MAX(IF($D$2:$D$100="Prevalence of recent intimate partner violence", IF($F$2:$F$100="Females 15-19", IF($G$2:$G$100=Q2, --$J$2:$J$100)))), --$J$2:$J$100, 0)), "id")
Lycias
Aug 24, 2023Brass Contributor
Revisiting this thread...Is it possible I to email you directly? I am nos sure why I still do not get the latest value of the indicator based on the most recent year.
- HansVogelaarAug 24, 2023MVP
You can send me a private message (click on my username)