查表 二者取最小區間 (12693)

E2=IFERROR(LOOKUP(1,0/(LEFT(G$4:G$6,3)-C2<=0)/(LEFT(OFFSET(H$4:H$6,,1-(B2="Male")),2)-D2<=0),J$4:J$6),J$4)