Hi!
I am a beginner in this index match function and I really need help now with one formula that cost me almost one day!

I need to get data for excel 1 from excel 2. take gross advertising revenue as an example, I use Index match function as row_number of match "gross advertising revenue" and column_num as "month" which is "SEPT"here.

The problem is that I can get value for array of index, and value for "SEPT" (column_num), but no value for the row_num.

Can any expert please help to check my formulas in excel one (2 yellow highlight part)?

Many thanks for help!!
Excel 1.xlsxExcel 2.xlsx