I need to match up population values for various countries, launch years, and age groups that vary across a time span.
I know that some sort of match/index and/or vlookup and/or hlookup is needed but I can't wrap my head around how these formulas relate to the page geometry.
Workbook attached.
If someone could adjust the existing non-working formula for the France, row 11257, I can do the rest.
The issue is to find the correct year and country, then sum up the population values for the age groups selected and plop that sum into the correct year column, and then onto the next year.
Any help is greatly appreciated!
File: forum.ozgrid.com/index.php?attachment/72182/