立體查詢 (13113)

M3:N8{=OFFSET($A$1,LOOKUP(MAX(($B$3:$J$15=$L3)*ROW($3:$15)),IF($A$2:$A$11="Shelf",ROW($1:$10)))+(A$2=$A$2),MAX(($B$3:$J$15=$L3)*COLUMN($A:$I))*(A$2=$B$2))