Match different dimensions

[Nelind]

Hello everyone,

I'm having trouble to merge two excel sheets on Year and Country base. attached please see the excel file. On the first sheet, I would like to fill column D with the corresponding (both year and country code base) "Total Eng" data from the second sheet. Could someone please help me to write a formula to merge these data? I would appreciate that..

thank you very much.

Nelind

[#2]

@Nelind 

Hi Nelind,

That could be

=IFERROR(INDEX(Sheet2!$D$2:$D$56,MATCH(1,INDEX((Sheet2!$B$2:$B$56=$A2)*(Sheet2!$C$2:$C$56=$B2),0),0)),"no such")

[#3]

A straightforward formula in D2, copied down rows, is:
=IFERROR(LOOKUP(PI(),
1/((Sheet2!B$2:B$56=A2)*(Sheet2!C$2:C$56=B2)),
Sheet2!D$2:D$56),
0)