Help with one index/Match formula, urgent!

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

Thanks so much for help!! what a stupid mistake!!

Originally Posted by sktneer

Hi Cecifiecc,
Welcome to the Forum.

Try this......

=INDEX('[Excel 2.xlsx]Consolidate P&L'!$L$11:$P$17,MATCH(B14,'[Excel 2.xlsx]Consolidate P&L'!$D$11:$D$17,0),MATCH(L$7,'[Excel 2.xlsx]Consolidate P&L'!$L$9:$P$9,0))

Also on Excel 2 workbook, in the range D11:D17, remove the colon ":" from the cell values because in Excel 1, B14:B20 doesn't contain that colon. Therefore either you remove it from one workbook or have colon in both the workbooks to have the similar matching values.

See if this helps.

Hello
Welcome to the forum
Finally I understood your problem...........
Quite twisting ....but simple
In B14 cell of Excel 1 you are missing a ":" after Gross advertising revenue....it should have been "Gross Advertising Revenue:"
That's why it returns an error
Hope it helps ....ask for any further doubts....

Regards
Sourabh

Yes,thanks for the help!!! Really appreciated!!!

Originally Posted by sourabhg98

Hello
Welcome to the forum
Finally I understood your problem...........
Quite twisting ....but simple
In B14 cell of Excel 1 you are missing a ":" after Gross advertising revenue....it should have been "Gross Advertising Revenue:"
That's why it returns an error
Hope it helps ....ask for any further doubts....

Regards
Sourabh