商品查找 格數不固定倉庫 (12699)

M2:M9{=IFERROR(LOOKUP(SUM((L2=$A$2:$J$9)*COLUMN($A:$J)),IF($A$1:$J$1<>"",COLUMN($A:$J)),$A$1:$J$1),"")

M2:M9複製到 O2:09  Q2lQ9