=MIN(B1,VLOOKUP(A1,{"A",1000;"B",800;"C",400;"D",400},2,0))
C2用公式：=IF(B1<>"",MIN(A1,LOOKUP(B1,{"A","B","C"},{1000,800,400})),"")下拉。
