I
Ian S
I have a datasheet that contains numeric values for a large number of
countries (rows) in multiple years (columns).
I want to insert two drop down lists into two cells of the worksheet - one
containing a list of countries and the other a list of years. When a country
and year is selected from each list, I want to have a function that will
return a specific value from the datasheet (the value for the selected
country in the selected year) into a third cell.
I need it to work so that each time I change the combination of country and
year using the two drop down lists, the value returned in the third cell
changes to the relevant value in the datasheet.
Does anyone know how I can achieve this, please.
countries (rows) in multiple years (columns).
I want to insert two drop down lists into two cells of the worksheet - one
containing a list of countries and the other a list of years. When a country
and year is selected from each list, I want to have a function that will
return a specific value from the datasheet (the value for the selected
country in the selected year) into a third cell.
I need it to work so that each time I change the combination of country and
year using the two drop down lists, the value returned in the third cell
changes to the relevant value in the datasheet.
Does anyone know how I can achieve this, please.