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.