Excel関数をシンプルにする

Sheet1のc26のExcel関数

IF(AND(OR(A1="FT", A1="SIT", A1="LOCAL"), OR(A2="T02", A2="T03", A2="T07")),
    IFERROR(
        VLOOKUP(
            A5,
            list!$B$13:$L$998,
            CHOOSE(
                MATCH(A2, {"T02","T03","T07"}, 0),
                IF(A1="FT",2,IF(A1="SIT",5,8)),
                IF(A1="FT",3,IF(A1="SIT",6,9)),
                IF(A1="FT",4,IF(A1="SIT",7,10))
            ),
            FALSE
        ),
        "未設定"
    ),
"未設定")

---

Sheet1

list