If I understand what you've done here, you've linked the most recent Mortality Ratios (2015) with the most recent Births Attended by Health Professional measure-- the year of which may vary.
I *think* Charles is looking to compare "apples to apples": in the case for the Bahamas, 2013 is the last reported year for Births Attended by Health Professional, so the Mortality Ratio should be 81 (2013's value), rather than 80 (2015's value).
Maybe I misunderstood & your elegant solution may be exactly what the Dr. ordered!
I appreciate your very quick response! I guess I had all my data formatted correctly and I was just doing the blend wrong. Michael's note above would be an improvement but seems very complex to me. The current solution gives the most recent data for each country, even if the two years don't match. For example, 2015 data for Maternal Mortality and 2012 data for Skilled Health Professional Assistance at Birth, if those are the most recent dates for each. Michael's proposal is to use most recent matching years, which is probably better in many cases, but complicated!
Thanks, Michael, that was my first thought as well, but later, I guess Charles's question is more related to how to blend the data sources. So I just show this first and in case there are more questions coming back will be also welcome.
And thanks Charles for your verify, I am glad to help