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
Excel formula - Urgent
2010-04-03 10:20 am
回答 (1)
2010-04-03 4:50 pm
收錄日期: 2021-04-27 13:22:57
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100403000051KK00190