Excel formula - Urgent

2010-04-03 10:20 am
I need create a quoation form but the price will change from different factors.

e.g. item 103 have 4 size, each size has different price

If I input the cell A1 is 103 and B1 is size 1. cell C1 can show the price is 10
If I input the cell A2 is 103 and B2 is size 2. cell C2 can show the price is 15


Please advise any formula can auto show the correct price

回答 (1)

2010-04-03 4:50 pm
✔ 最佳答案
use SUMPRODUCT

Please download the file for reference: http://www.FunP.Net/291535


收錄日期: 2021-04-27 13:22:57
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100403000051KK00190

檢視 Wayback Machine 備份