=vlookup(SHEET1!A1,SHEET2!$A$1:$B$20,2,0)*A1假设折扣表在sheet2的A到B列
=VLOOKUP(A3,E1:F7,2,0)*B3把英文名称去掉，汉语复制过去，
=A2*VLOOKUP(A2,E:F,2,0)下拉看看
