1. F2 的formula输入以下函数

            
=VLOOKUP(E2,N:O,2,0)*D2
            
          

2. 再copy F2复制到F3-F4 (往下拖延也可以)




3. 完成

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---