你開個頭我睇下引唔引導到你做落去
我貼個答案俾你你都唔會學到野
你唔會明我寫果陣諗緊乜
因為有時睇番我自己都唔明做緊乜
ws.PageSetup.PrintArea = ""
=IFERROR(INDEX($C$8:$C$13,MATCH(1,($A3=$B$8:$B$13)*(B$1=$A$8:$A$13),0))," ")
=IFERROR(INDEX($D$8:$D$13,MATCH(1,($B3=$C$8:$C$13)*(B$1=$A$8:$A$13)*($A3=$B$8:$B$13),0))," ")
=IFERROR(INDEX($E$8:$E$13,MATCH(1,($B3=$C$8:$C$13)*(B$1=$A$8:$A$13)*($A3=$B$8:$B$13),0)),"")