多表 取不重複產品名稱與數值 (14952)

J2:J19 產品不重複{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(J$1:J1,A$2:G$15)=0)*(A$1:G$1=A$1)*(A$2:G$15<>""),ROW($2:$15)/1%+COLUMN(A:G))),"!R0C00"),),"")

K2:M19=IFERROR(VLOOKUP($J2,OFFSET($A$2,,MATCH(K$1,$1:$1,)-2,19,2),2,),"")

N2:N19=IF(J2="","",SUM(K2:M2))