How to call the unit price in another worksheet when calculating piece rate in EXCEL?

You can use the VLOOKUP function to link unit prices.

1. All styles in the numbered price list can be quickly entered by using English numbers or abbreviations. Generally, it is placed in column A, column B is the style description, column C is the unit price, and the worksheet is named-price list or other names.

2. Keep the price list open, and create a new worksheet-column A of the statistical table is the employee's name, column B is the code (according to the code in the price list), column C is the unit price, and C2 cell input =IF(IF(A2= "","",VLOOKUP(A2,' [price list. xls]Sheet 1 '！ $A:$C, 3, 0)), drop-down formula

The unit price of the price list can be changed at any time, and the statistical table will be changed accordingly.

You can also put two tables in the workbook sheet 1 sheet2 for easy search.

202 1 When will the recruitment of Wuzhi public kindergarten come out?

Are the costumes for the Oriental Olympic Games sponsored?

Why is baby cashmere more expensive than milk cashmere?

Works based on background materials

Which country's brand is mango?

How do different people enter the summer safely?

Aesthetic Poems on Family Portraits

How about Shanghai Fulai Trading Co., Ltd.?

Uniqlo surpassed ZARA in market value and became the first in the clothing industry. What do you think of these two brands?

What brand of scissors is better to use?