Forum Discussion
Match different dimensions
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 (b...
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)
=IFERROR(LOOKUP(PI(),
1/((Sheet2!B$2:B$56=A2)*(Sheet2!C$2:C$56=B2)),
Sheet2!D$2:D$56),
0)