男女多種稱呼 判斷 (14598)

E2=LEFT(B2)&IF((C2="女")*(D2="已婚"),"太太",MID("弟弟先生叔叔妹妹小姐伯母",(LOOKUP(IFERROR(LEFTB(D2,2)*1,20),{0,20,60},{1,2,3})+(C2="女")*3)*2-1,2))