Vlookup/Index(Match)/Hlookup

[mickeystanford_alumni]

Hi guys,
I hope you are well. I am trying to build a table with a bunch of information. I am struggling to use a vlookup+hlookup formula or index(match) as it has more than 2 variables.

Data:

Year	Month	Sales	Revenue
2015​	1​	50​	100​
2016​	2​	40​	150​

Chart I am trying to build:

Revenue	1​	2​
2015​
2016​

Thanks a lot

 

[Joe4]

It looks to me like you are trying to get sum, so the SUMIFS function, which allows for multiple criteria, seems like it should work here.
See: MS Excel: How to use the SUMIFS Function (WS)