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 (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 Replies
- 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) 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")
