Traditional Culture Encyclopedia - Hotel reservation - How to set the corresponding price for each dish name in excel without having to re-enter the price separately when summarizing?
How to set the corresponding price for each dish name in excel without having to re-enter the price separately when summarizing?
Design a price list first. You can put it in sheet2 or with sheet 1.
Suppose the name of column A, the price of column B, the quantity of column C and the total price of column D, and columns F and G are price lists.
Enter the formula in cell B2:
=vlookup(a2,$F$2:$G$ 10,2,0)
Enter the formula in cell D2:
=B2*C2
Then select the "B2:D2" cell and drag the fill handle to fill it down.
The attachment is an xls file and can be downloaded.
- Related articles
- Is Yutian community good?
- Train route from Pagoda
- Watch fireworks composition
- How to get from Gushu Metro Station to Oriental Shanshui Hotel (Shenzhen Airport Branch)
- Which is better, Xuchang Baili Hotel or Zhongyuan Holiday?
- Where is the Cologne Game Show held?
- How many kilometers is it from Wujiang Tongluo to Lijiang, Yunnan
- Which company was the first developer of Yunxing Park in Ganzhou?
- How about Hengshui Jinshu Landscaping Technology Co., Ltd.?
- Is the traffic in Hongshuwan convenient? How should I get there?