May 06 2019 07:22 AM
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
May 06 2019 07:48 AM
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")
May 06 2019 08:04 PM