How to use index match for multiple rows

Hi,

I have an Excel file with lots of data and I would like to find some KPI from the data.
The raw data consists of lots off different KPI for several companies and over a period of time and I need to extract some specific KPI for several companies.

The issue is that each company do not have the same year in the same column.

I use the following formula and it works perfect if all companies should have the same parameter in row 2 (that is years), but since they start in different years do I need to adjust what row to search for the column (see below in bold where I have my issues).

Formula today (DATA is the tab with all data):

=IFERROR(INDEX(DATA!$A:$X;MATCH($B3&$C3;DATA!$X:$X;0);MATCH(D$2;DATA!$2:$2;0));"")

Picture Excel.PNG
This is a picture of the tab with the formula.

I hope my question is clear to you and there is someone that might be able to help me.

Post edited with Excel-file to show issue.

BR
Sebastian

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

Perfect!! In E3, coped across and down:

=IFERROR(INDEX(Excelfiler,MATCH($B3&$C3,Excelfiler[[Formula]:[Formula]],0),MATCH(E$2,INDEX(Excelfiler,MATCH($B3,Excelfiler[[Source.Name]:[Source.Name]],0),),0)),"")