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...
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")