取各投保金額 依薪資 (11475)

C4:E10{=TEXT(MIN(IF(N(OFFSET($G$2,ROW($1:$10),MATCH(C$3,$H$2:$J$2,)+{0,4}))>=$B4,N(OFFSET($G$2,ROW($1:$10),MATCH(C$3,$H$2:$J$2,)+{0,4})))),"0;;"&MAX(N(OFFSET($G$2,ROW($1:$10),MATCH(C$3,$H$2:$J$2,)+{0,4}))))