Catering, is there a function in excel that shows the unit price of A1 in D1, knowing the name in A1 and the unit in C1?

1. Enter the name and unit price of the dish in advance in sheet2 (this unit price can be modified at any time), as shown in the following figure

2. In sheet1, select column A, set the data validity, select the sequence, and set the source in sheet2! $A$2:$A$1111 (this 1111 depends on how many dishes you have). Set B2 formula to =IFERROR(VLOOKUP($A2,Sheet2! $A:$C,2,1), ""), C2 formula is =IFERROR(VLOOKUP($A2,Sheet2! $A:$C,3,1), ""), E2 formula is =IFERROR(C2*D2,1). Then pull down the B2 C2 E2 formula to fill it.

when you need to register in the future, you only need to select the name of the dish in column A, enter the quantity in column D, and the unit price amount will be automatically generated.

October 30 Harbin Nangang District part of the region to implement temporary control measures (scope + service hotline)

The consumption of prefabricated vegetables is heating up, and the "post-95 s" group has become the main consumer. What are the characteristics of prefabricated vegetables?

What is the impact of the uncertainty of the annual assessment level of institutions in Yingzhou District, Fuyang City, Anhui Province?

Putin called the war "positive", NATO Secretary General: I don't expect the normalization of relations between the West and Russia.

Reveal the geomantic omen and function of office furniture placement

How to handle the transformation and upgrading of individual industrial and commercial households?

How about Shenyang Danggui Catering Management Co., Ltd.?

Yulin catering equipment wholesale telephone

I'm getting married next year. Could you tell me which hotels in Yangpu District are suitable for holding wedding banquets?

What about Beijing Youhe World Catering Management Co.