判斷 级别 (10146)


E2=LOOKUP(D2,LEFT(A$2:A$6,FIND("-",A$2:A$6)-1)*1,B$2:B$6)


F2=VLOOKUP(D2,H:I,2,1)


留言