Match and Index

[zeez36]

Dear all,

I need a help to get data from sheet2 columnD (Total Sales) and add them to sheet1 based on

1. Showroom code (column E) sheet2
2. Date (Column C) sheet2

[CARACALLA]

Sheet1

C5=SUMIFS(Sheet2!$D$2:$D$10,Sheet2!$E$2:$E$10,Sheet1!C$4,Sheet2!$C$2:$C$10,Sheet1!$A5)

Copy across and down

[zeez36]

Thanks a lot for your fast reply

But I need to get the last value in column D from Sheet2, as if I have double date, the equation get the last value.

[Bo_Ry]

Please try at C5

=IFNA(LOOKUP(2,1/(Sheet2!$C$2:$C$10=$A5)/(Sheet2!$E$2:$E$10=C$4),Sheet2!$D$2:$D$10),"")

[zeez36]

Thanks a lot

That is exactly what I need