Conditional displaying using 3 parameters

[Excelisimo]

Dear users,

I have to link cells from file 1 into file 2, but the problem is that the format of the two files are different.

What I want is that...
... C9 (file 2) displays E3 (file 1) --> Both display week 46 - file type A - forecast
... D9 (file 2) displays L3 (file 1) --> Both display week 46 - file type A - confirmed
... F9 (file 2) displays F3 (file 1) --> Both display week 46 - file type B - forecast
... G9 (file 2) displays M3 (file 1) --> Both display week 46 - file type B - confirmed
... I9 (file 2) displays E4 (file 1) --> Both display week 47 - file type A - forecast
... J9 (file 2) displays L4 (file 1) --> Both display week 47 - file type A - confirmed
... etc.

I already tried to work with IF statements...
...For instance for week 46 for file type A forecast I tried IF D3= 46 then display E3, IF D4 = 46 then display E4, etc.
...For week 47 for file type A forecast: IF D3= 47 then display E3, IF D4 = 47 then display E4, etc.
... but I could not make these formulas working or compact.

Can anybody help me with the right formula to display the right cell from file 1 into file 2 based on the parameters: week number, file type A/B, forecast/confirmed

Linking each cell one by one would be to big of a job because I have to do this for 10 different teams.

File 1

File 2