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
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
Last edited by zeez36; 10-22-2020 at 07:03 AM.
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
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.
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),"")
Thanks a lot
That is exactly what I need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks