J8 和J16 数据不对,麻烦再看看咯
追答=IF(H2<80,IF(ISERROR(VLOOKUP(G2,B$2:C$10,2,0)),VLOOKUP(G2,$B$12:$E$100,2,),VLOOKUP(G2,B$2:C$10,2,0)),IF(H2<150,IF(ISERROR(VLOOKUP(G2,B$2:D$10,3,0)),VLOOKUP(G2,B$12:C$100,2,0),VLOOKUP(G2,B$2:D$10,3,0)),VLOOKUP(G2,B$12:D$100,3,0)))