Lookup datas in two columns return results from a third one

Hello I’m looking for a way to return the value from a cell in which row two columns correspond to the values I’m looking for.

To make it clear I have spreadsheet with column A being year, column B being month and another 10 columns being meteorological data. I want to make a new matrix were I have in rows the years and in columns the months and having the responding value of lets say the seventh column filled in. The formula should look at the year value in the row and the month value in the column of the new matrix and match them with the year value and the month value of the old matrix, finding the unique row and return the value of the ninth column of that row.

MATCH, OFFSET and a new concatenated row with e.g “2014-05” for matching is how I would do it.

I think pivot table can be your tool.

Menu/Data/Pivot table.

Thank you for the responses

I was hoping for something simpler but according to what I see probably I will have to go with a new concatenated column combining year and month, I find it easier than pivot table. It would be very convenient if a function like multiple check Vlookup existed.