There may be an easy solution to this query as it seems quite simple but i'm
tying my brain in knots trying to figure it out!

I have a table in a sheet which i want to populate with data from a table in
another sheet. the table i want to populate has a range of age groups down
the column and some different types of households (eg, 1 person male, 1
person female, 2 person 2 adult, 2 person 1 parent,etc) along the row. There
is a cell above it for the year.

The table i want to use to fill this one has the age ranges in column B, the
household types in column C and the years from 2006 to 2031 along row 2.

Ideally i would like to be able to write a formaula in the cells of the
table i need to fill so that if i change the cell at the top of it with the
date then all the data in the table will change accordingly. I dont mind
putting in the complicated work just now if it will save me time in future
years.

Vlookup and Hlookup only let me search one row or column. I cant believe
there is no way of searching a table using more than one variable but i cant
figure it out! can anybody help with this?