Hlookup with two conditions?

[bnbrilhart]

I am working with a file that includes year in one row and the month in the row below. I need a formula that can match the year and month and return the value directly below the month in the same column.

Thank you for any help!

 

[Special-K99]

Given

a a b
1 2 2
4 5 6

and lookup values of a and 2
=HLOOKUP("a",IF(A2:C2=2,A1:C3),3,0)
Array formula, use Ctrl-Shift-Enter

returns 5

 

[roelandwatteeuw]

Not possible in one move, I think.
What I learned is that you need to make an extra column with the combination of the year and month.
Use your Look-Up on this cell.

Here some information:
Perform VLOOKUP with 2 lookup values | wmfexcel