How to do the excel list table: First use the formula in list H4 [=Calculation Sheet!G4]; then click on the G4 cell of the calculation sheet, open the name manager, and customize the formula [=EVALUATE(Calculation Sheet!$ H4)].

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to do excel list table:

1. As shown in the figure, the E4 formula of the calculation table: =IF(D4=List!B4,"√","" ) , G4 formula: =IF((E4="") (H4=""),"",JS)

List H4 formula: =calculation table!G4

2, Click on cell G4 of the calculation table, as shown in the figure to open the name manager and customize the formula. The formula inside is:

=EVALUATE(calculation table!$H4)

3. Remember to save as .xlsm format when saving.

Related learning recommendations: excel tutorial

The above is the detailed content of How to make excel list table. For more information, please follow other related articles on the PHP Chinese website!