In Excel, what formula is used to extract an expense from several expense tables?

This question can be generated once with the PivotTable report, and the method is as follows:

1. I added a title to the original table, as shown below:

2. Select cell A8: C 16 at the same time, press ALT, N, V and T respectively, and click OK to open the following dialog box:

3. Check "Attribute Location" and drag it to "Column Label";

4. Uncheck the "parking fee" in the fee name (see the above figure), and then drag it to the column label;

5. "Expense Amount" is directly dragged into "Value".

As shown in the figure below:

6. Select the newly generated A3: B 1 1 table area, right-click the PivotChart Options-Display tab, select the classic PivotChart layout, then put away all the+signs and-signs, right-click the B column and hide it. Get the target table. ?

There are other ways, but the pivotchart is simpler. look

7. From the generated table, use the vlookup formula and import it directly into your second table.

Hope to adopt, thank you.