1. Step 1: Enter the key data in the cell, and then extract it into the "Company Standard" column of the corresponding store name according to the "Company Status" data, as shown in the following figure, and enter the following steps.

2. Step 2: Click ""after completing the above steps.

? Fx "to insert the function, and then select the" VLOOKUP "function, as shown in the figure below, and go to the following steps.

3. Step 3: After completing the above steps, set the parameters in the opened function parameter settings as shown in the following figure, and enter the following steps.

4. Step 4: After completing the above steps, click Enter to generate calculation results and fill in the formula to get the standard data of listed companies corresponding to all store names, as shown in the following figure. In this way, the problem is solved.